5 New Messages
Digest #2573
1b
Re: Error with RCHGetElementNumber() for Morningstar Element Numbers by "Randy Harmelink" rharmelink
Messages
Fri Apr 5, 2013 4:23 pm (PDT) . Posted by:
"joshdramsey" joshdramsey
Hi,
I'm new to the group, and I'm having trouble with most of the Morningstar Element Numbers. I'm not sure if I'm missing something obvious, or if this is a problem for everyone.
Some of the element numbers return the correct values. For example, RCHGetElementNumber("AAPL";,887) returns the correct value. The element numbers 14344 - 14398 also work. The element number 14343, however, returns an ERROR. I've tried a sampling of the element numbers for Morningstar and most of them do not work. It doesn't seem to matter whether I'm logged in to Morningstar (through my library account) or not.
Any thoughts on what I should try next?
Thanks!
Josh
I'm new to the group, and I'm having trouble with most of the Morningstar Element Numbers. I'm not sure if I'm missing something obvious, or if this is a problem for everyone.
Some of the element numbers return the correct values. For example, RCHGetElementNumber
Any thoughts on what I should try next?
Thanks!
Josh
Sat Apr 6, 2013 12:34 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Hmmm. Element #887 should be undefined.
A number of MorningStar elements no longer work, because MorningStar has
made the web pages dynamic. The add-in picks up the data from the source
code of the web page, so dynamic web pages don't have the data available
for extraction. They seem to be making more and more of their web pages
dynamic as time goes on.
As an alternative, MorningStar is also producing some CSV files now. See:
http://finance.groups.yahoo.com/group/smf_addin/message/19776
On Fri, Apr 5, 2013 at 3:14 PM, joshdramsey <joshdramsey@yahoo.com > wrote:
> Hi,
>
> I'm new to the group, and I'm having trouble with most of the Morningstar
> Element Numbers. I'm not sure if I'm missing something obvious, or if this
> is a problem for everyone.
>
> Some of the element numbers return the correct values. For example,
> RCHGetElementNumber("AAPL";,887) returns the correct value. The element
> numbers 14344 - 14398 also work. The element number 14343, however,
> returns an ERROR. I've tried a sampling of the element numbers for
> Morningstar and most of them do not work. It doesn't seem to matter
> whether I'm logged in to Morningstar (through my library account) or not.
>
> Any thoughts on what I should try next?
>
A number of MorningStar elements no longer work, because MorningStar has
made the web pages dynamic. The add-in picks up the data from the source
code of the web page, so dynamic web pages don't have the data available
for extraction. They seem to be making more and more of their web pages
dynamic as time goes on.
As an alternative, MorningStar is also producing some CSV files now. See:
http://finance.
On Fri, Apr 5, 2013 at 3:14 PM, joshdramsey <joshdramsey@
> Hi,
>
> I'm new to the group, and I'm having trouble with most of the Morningstar
> Element Numbers. I'm not sure if I'm missing something obvious, or if this
> is a problem for everyone.
>
> Some of the element numbers return the correct values. For example,
> RCHGetElementNumber
> numbers 14344 - 14398 also work. The element number 14343, however,
> returns an ERROR. I've tried a sampling of the element numbers for
> Morningstar and most of them do not work. It doesn't seem to matter
> whether I'm logged in to Morningstar (through my library account) or not.
>
> Any thoughts on what I should try next?
>
Sat Apr 6, 2013 12:06 am (PDT) . Posted by:
"zbgb952" zbgb952
Hello Randi..
I just tried to open
RCH_Stock_Market_Functions-2.1.2013.03.29.zip
in the works in progress fold and it told me file could not be found.
Also, I downloaded it..something downloaded , but I couldn't open it..got message saying file is invalid.
--- In smf_addin@yahoogroups.com , "Randy H" <rharmelink@...> wrote:
>
> I don't automatically update the beta version unless it's a fix of
> something. Or has something new that was specifically asked for. I also
> haven't written up documentation for the new function yet, or added it
> as a data source to smfGetOptionQuotes().
>
> I happened to need to get historical option quotes a while back, and
> found out they were available on BigCharts, so I wrote a little
> function to grab them. I update the change log when I do changes so that
> if people see something there they could use, they can let me know and
> I'll do a new release.
>
> And, to tell the truth, I have a concern about even releasing the
> function for general use, because each historical date requires a
> separate Internet access. The last thing I would want is for people to
> retrieve numerous strike prices and dates. My own usage was to get a
> single quote at each expiration date, for a single strike price. So I
> accessed about a dozen web pages.
>
> But, since you asked, version 2.1.2012.03.29 is now available in the
> "Works in Progress" folder.
>
> As far as I can tell, you can only get historical quotes on existing
> contracts. It appears to me that if the contract has expired, the
> historical data is no longer available.
>
> Function format:
>
> =smfGetBigChartsOptionQuote(equity ticker,C/P,Expiry,Strike,Data
> code,[optional Historical Date])
>
> Sample current option quote parameters:
>
> Description Value Equity C/P Expiry Strike Code Ask price
> $11.84 SPY C 2014-01-18 150 a Bid price $11.65 SPY C
> 2014-01-18 150 b $ Change $0.18 SPY C 2014-01-18 150 c
> Open Interest 18006 SPY C 2014-01-18 150 i Last price $11.60
> SPY C 2014-01-18 150 l Strike price 150 SPY C 2014-01-18
> 150 s Last price of underlying equity $156.67 SPY C 2014-01-18
> 150 u Volume 56 SPY C 2014-01-18 150 v Option
> expiration date 41657 SPY C 2014-01-18 150 x Option ticker
> symbol SPYA18143150000 SPY C 2014-01-18 150 z
> Sample historical quote parameters:
>
> Description Value Equity C/P Expiry Strike Code Historical Date
> Historical Date Fri, Mar 01, 2013 SPY C 2014-01-18 150 d
> 2013-03-01 Low price 8.11 SPY C 2014-01-18 150 g 2013-03-01
> High Price 8.93 SPY C 2014-01-18 150 h 2013-03-01 Last Price
> (i.e. closing) 8.87 SPY C 2014-01-18 150 l 2013-03-01 Open
> price 8.28 SPY C 2014-01-18 150 o 2013-03-01 Volume 62 SPY
> C 2014-01-18 150 v 2013-03-01 Option ticker symbol SPDR 500
> Jan 2014 Call 150.00 SPY C 2014-01-18 150 z 2013-03-01
> On Fri, Mar 29, 2013 at 11:13 AM, Sharon McAllister
> <sharonnraymc@... <mailto:sharonnraymc@...> > wrote:
>
> Hi Randy, When will you be updating the latest beta version of the
> add-in? I noticed in the Change-Log for your beta version an entry on
> 2013-03-02 for smfGetBigChartsOptionQuote, yet this function is not in
> the latest beta version that's available from the work in progress
> folder. It's possible you are still working out some kinks which is why
> the latest beta version is dated 2/1/2013. This is the version I am
> on: Stock Market Functions add-in, Version 2.1.2013.01.04
> I'm quite interested in giving this function,
> smfGetBigChartsOptionQuote a whirl to see if there is a useful way to
> back test various option strategies.
> Many thanks for all the work you've put into this add-in. It is a
> tremendously useful tool.Sharon
>
I just tried to open
RCH_Stock_Market_
in the works in progress fold and it told me file could not be found.
Also, I downloaded it..something downloaded , but I couldn't open it..got message saying file is invalid.
--- In smf_addin@yahoogrou
>
> I don't automatically update the beta version unless it's a fix of
> something. Or has something new that was specifically asked for. I also
> haven't written up documentation for the new function yet, or added it
> as a data source to smfGetOptionQuotes(
>
> I happened to need to get historical option quotes a while back, and
> found out they were available on BigCharts, so I wrote a little
> function to grab them. I update the change log when I do changes so that
> if people see something there they could use, they can let me know and
> I'll do a new release.
>
> And, to tell the truth, I have a concern about even releasing the
> function for general use, because each historical date requires a
> separate Internet access. The last thing I would want is for people to
> retrieve numerous strike prices and dates. My own usage was to get a
> single quote at each expiration date, for a single strike price. So I
> accessed about a dozen web pages.
>
> But, since you asked, version 2.1.2012.03.
> "Works in Progress" folder.
>
> As far as I can tell, you can only get historical quotes on existing
> contracts. It appears to me that if the contract has expired, the
> historical data is no longer available.
>
> Function format:
>
> =smfGetBigChartsOpt
> code,[optional Historical Date])
>
> Sample current option quote parameters:
>
> Description Value Equity C/P Expiry Strike Code Ask price
> $11.84 SPY C 2014-01-18 150 a Bid price $11.65 SPY C
> 2014-01-18 150 b $ Change $0.18 SPY C 2014-01-18 150 c
> Open Interest 18006 SPY C 2014-01-18 150 i Last price $11.60
> SPY C 2014-01-18 150 l Strike price 150 SPY C 2014-01-18
> 150 s Last price of underlying equity $156.67 SPY C 2014-01-18
> 150 u Volume 56 SPY C 2014-01-18 150 v Option
> expiration date 41657 SPY C 2014-01-18 150 x Option ticker
> symbol SPYA18143150000 SPY C 2014-01-18 150 z
> Sample historical quote parameters:
>
> Description Value Equity C/P Expiry Strike Code Historical Date
> Historical Date Fri, Mar 01, 2013 SPY C 2014-01-18 150 d
> 2013-03-01 Low price 8.11 SPY C 2014-01-18 150 g 2013-03-01
> High Price 8.93 SPY C 2014-01-18 150 h 2013-03-01 Last Price
> (i.e. closing) 8.87 SPY C 2014-01-18 150 l 2013-03-01 Open
> price 8.28 SPY C 2014-01-18 150 o 2013-03-01 Volume 62 SPY
> C 2014-01-18 150 v 2013-03-01 Option ticker symbol SPDR 500
> Jan 2014 Call 150.00 SPY C 2014-01-18 150 z 2013-03-01
> On Fri, Mar 29, 2013 at 11:13 AM, Sharon McAllister
> <sharonnraymc@
>
> Hi Randy, When will you be updating the latest beta version of the
> add-in? I noticed in the Change-Log for your beta version an entry on
> 2013-03-02 for smfGetBigChartsOpti
> the latest beta version that's available from the work in progress
> folder. It's possible you are still working out some kinks which is why
> the latest beta version is dated 2/1/2013. This is the version I am
> on: Stock Market Functions add-in, Version 2.1.2013.01.
> I'm quite interested in giving this function,
> smfGetBigChartsOpti
> back test various option strategies.
> Many thanks for all the work you've put into this add-in. It is a
> tremendously useful tool.Sharon
>
Sat Apr 6, 2013 12:09 am (PDT) . Posted by:
"zbgb952" zbgb952
tried it again 15 minutes later and it worked..
--- In smf_addin@yahoogrou
>
> Hello Randi..
> I just tried to open
>
> RCH_Stock_Market_
>
> in the works in progress fold and it told me file could not be found.
> Also, I downloaded it..something downloaded , but I couldn't open it..got message saying file is invalid.
>
> --- In smf_addin@yahoogrou
> >
> > I don't automatically update the beta version unless it's a fix of
> > something. Or has something new that was specifically asked for. I also
> > haven't written up documentation for the new function yet, or added it
> > as a data source to smfGetOptionQuotes(
> >
> > I happened to need to get historical option quotes a while back, and
> > found out they were available on BigCharts, so I wrote a little
> > function to grab them. I update the change log when I do changes so that
> > if people see something there they could use, they can let me know and
> > I'll do a new release.
> >
> > And, to tell the truth, I have a concern about even releasing the
> > function for general use, because each historical date requires a
> > separate Internet access. The last thing I would want is for people to
> > retrieve numerous strike prices and dates. My own usage was to get a
> > single quote at each expiration date, for a single strike price. So I
> > accessed about a dozen web pages.
> >
> > But, since you asked, version 2.1.2012.03.
> > "Works in Progress" folder.
> >
> > As far as I can tell, you can only get historical quotes on existing
> > contracts. It appears to me that if the contract has expired, the
> > historical data is no longer available.
> >
> > Function format:
> >
> > =smfGetBigChartsOpt
> > code,[optional Historical Date])
> >
> > Sample current option quote parameters:
> >
> > Description Value Equity C/P Expiry Strike Code Ask price
> > $11.84 SPY C 2014-01-18 150 a Bid price $11.65 SPY C
> > 2014-01-18 150 b $ Change $0.18 SPY C 2014-01-18 150 c
> > Open Interest 18006 SPY C 2014-01-18 150 i Last price $11.60
> > SPY C 2014-01-18 150 l Strike price 150 SPY C 2014-01-18
> > 150 s Last price of underlying equity $156.67 SPY C 2014-01-18
> > 150 u Volume 56 SPY C 2014-01-18 150 v Option
> > expiration date 41657 SPY C 2014-01-18 150 x Option ticker
> > symbol SPYA18143150000 SPY C 2014-01-18 150 z
> > Sample historical quote parameters:
> >
> > Description Value Equity C/P Expiry Strike Code Historical Date
> > Historical Date Fri, Mar 01, 2013 SPY C 2014-01-18 150 d
> > 2013-03-01 Low price 8.11 SPY C 2014-01-18 150 g 2013-03-01
> > High Price 8.93 SPY C 2014-01-18 150 h 2013-03-01 Last Price
> > (i.e. closing) 8.87 SPY C 2014-01-18 150 l 2013-03-01 Open
> > price 8.28 SPY C 2014-01-18 150 o 2013-03-01 Volume 62 SPY
> > C 2014-01-18 150 v 2013-03-01 Option ticker symbol SPDR 500
> > Jan 2014 Call 150.00 SPY C 2014-01-18 150 z 2013-03-01
> > On Fri, Mar 29, 2013 at 11:13 AM, Sharon McAllister
> > <sharonnraymc@ <mailto:sharonnr
> >
> > Hi Randy, When will you be updating the latest beta version of the
> > add-in? I noticed in the Change-Log for your beta version an entry on
> > 2013-03-02 for smfGetBigChartsOpti
> > the latest beta version that's available from the work in progress
> > folder. It's possible you are still working out some kinks which is why
> > the latest beta version is dated 2/1/2013. This is the version I am
> > on: Stock Market Functions add-in, Version 2.1.2013.01.
> > I'm quite interested in giving this function,
> > smfGetBigChartsOpti
> > back test various option strategies.
> > Many thanks for all the work you've put into this add-in. It is a
> > tremendously useful tool.Sharon
> >
>
Sat Apr 6, 2013 12:36 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I just tried it and it worked fine for me...
Possibly a temporary glitch on Yahoo's part?
On Sat, Apr 6, 2013 at 12:06 AM, zbgb952 <mb0329@msn.com> wrote:
>
> I just tried to open
>
> RCH_Stock_Market_Functions-2.1.2013.03.29.zip
>
> in the works in progress fold and it told me file could not be found.
> Also, I downloaded it..something downloaded , but I couldn't open it..got
> message saying file is invalid.
>
Possibly a temporary glitch on Yahoo's part?
On Sat, Apr 6, 2013 at 12:06 AM, zbgb952 <mb0329@msn.com> wrote:
>
> I just tried to open
>
> RCH_Stock_Market_
>
> in the works in progress fold and it told me file could not be found.
> Also, I downloaded it..something downloaded , but I couldn't open it..got
> message saying file is invalid.
>
Tidak ada komentar:
Posting Komentar