Messages In This Digest (7 Messages)
- 1a.
- Re: =RCHGetYahooHistory updating very slow From: draz2121
- 1b.
- Re: =RCHGetYahooHistory updating very slow From: Randy Harmelink
- 2a.
- Re: options quotes From: three100mph
- 3a.
- elements from sources other than MSN From: shanmuk123
- 3b.
- Re: elements from sources other than MSN From: Randy H
- 3c.
- Re: elements from sources other than MSN From: shanmuk123
- 3d.
- Re: elements from sources other than MSN From: Randy Harmelink
Messages
- 1a.
-
Re: =RCHGetYahooHistory updating very slow
Posted by: "draz2121" bolony21@gmail.com draz2121
Sat Jan 28, 2012 4:25 am (PST)
Shame, it seems to be Yahoo that updates these prices late.
Some were not updated until after 11:30am GMT.
Our markets open at 08:00 GMT so need this data before this time (none had updated before this time).
Do you know of any alternatives to grab historical data such as this?
Thanks.
--- In smf_addin@yahoogroups.com , "draz2121" <bolony21@...> wrote:
>
> I don't use IE but understand form that message that Excel uses IE's settings.
>
> I did indeed need to change this setting so I will know if this worked tonight :)
>
> Thanks.
>
> --- In smf_addin@yahoogroups.com , "Randy H" <rharmelink@> wrote:
> >
> > American stocks are usually updated within several hours of the NYSE
> > close...
> >
> > Is it possible you just have a caching problem?
> >
> > http://finance.groups.yahoo. com/group/ smf_addin/ message/13523
> >
> > On Fri, Jan 27, 2012 at 4:43 AM, Shaun <bolony21@> wrote:
> >
> > Well, I will check but I would expect the previous days EOD to be
> > available before the market open on the next day?
> > Almost all had updated to 26th Jan data by 10am this morning but none
> > had updated before 8am when I need the data.
> > I'm baffled too....
> >
>
- 1b.
-
Re: =RCHGetYahooHistory updating very slow
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Jan 28, 2012 7:35 am (PST)
I don't do anything with LSE stocks...
On Sat, Jan 28, 2012 at 5:25 AM, draz2121 <bolony21@gmail.com > wrote:
> Shame, it seems to be Yahoo that updates these prices late.
>
> Some were not updated until after 11:30am GMT.
>
> Our markets open at 08:00 GMT so need this data before this time (none had
> updated before this time).
>
> Do you know of any alternatives to grab historical data such as this?
>
- 2a.
-
Re: options quotes
Posted by: "three100mph" three100mph@yahoo.com three100mph
Sat Jan 28, 2012 7:31 am (PST)
Ah, yes it does pay to read ALL the docs. I got so fixated on testing the functions listed in the overview I failed to to read the note at the bottom that says to check for other functions in the folder.
These options functions look great, I will be trying them out this weekend.
Thanks for your help getting me started in the right direction.
--- In smf_addin@yahoogroups.com , "Randy H" <rharmelink@...> wrote:
>
> While "IBM120218C00185000" may be the defined standard form of the
> option symbol, it is not what all data sources use. For example, both
> Google and Yahoo use it, but MSN would use ".IBM\12B18\185.0" and
> OptionsXPress would use "IBM^^^120218C00185000".
>
> That's why when I wrote the smfGetOptionQuotes() function, I created a
> verbiage based option symbol and then have the add-in function convert
> it to be what the individual data sources need. It also allows the
> options symbol to be what people typically SAY when describing an
> option, so it's self-documenting. For example, to get the bid price for
> said option from OptionsXPress, you could use either of:
>
> =smfGetOptionQuotes("IBM 2/18 2012 $185 Call","b",," OX")
> =smfGetOptionQuotes("IBM Feb 2012 $185 Call","b",," OX")
>
> I note you didn't indicate which function you are using when getting
> nothing back, so it could be you are trying to use the
> RCHGetYahooQuotes() function. Yahoo used to return option quotes via
> their CSV interface. However, they stopped providing the quotes there
> when the new option symbology was adopted. Which is one of the reasons I
> ended up writing my own function above to get the option quotes.
>
> Other than OptionsXPress (which is actually trading the options, so they
> need to be up-to-date and accurate), I find the various sources to be
> spotty on coverage, especially on the weekly options. But OptionsXPress
> is also the slowest source of the data.
>
> On Fri, Jan 27, 2012 at 3:44 PM, three100mph <three100mph@> wrote:
> Hi, these are great tools and I got the quotes to work for stocks but I
> am having trouble with options. Option symbols have now been
> standardized with a form like "IBM120218C00185000" for the Feb 18,2012
> 185 IBM CALL option. When I try to use these types of codes I can get
> nothing back of any use. Do you have any ideas on this problem?
>
- 3a.
-
elements from sources other than MSN
Posted by: "shanmuk123" shanmuk123@yahoo.com shanmuk123
Sat Jan 28, 2012 5:35 pm (PST)
I just joined. I get an error for any element number not associated with MSN...thanks
- 3b.
-
Re: elements from sources other than MSN
Posted by: "Randy H" rharmelink@gmail.com rharmelink
Sat Jan 28, 2012 5:37 pm (PST)
More specifics please -- ticker symbol, element number?
If they are AdvFN elements, you may need to apply the fix suggested in
the "Links" area of the group.
Or, you may be using ticker symbols that are specific to MSN.
--- In smf_addin@yahoogroups.com , "shanmuk123" <shanmuk123@...> wrote:
>
> I just joined. I get an error for any element number not associated
with MSN...thanks
- 3c.
-
Re: elements from sources other than MSN
Posted by: "shanmuk123" shanmuk123@yahoo.com shanmuk123
Sat Jan 28, 2012 6:30 pm (PST)
Any ticker symbol and element number between 540 and 552 inclusive, Randy. On your spreadsheet that shows element number and source, elements 540 to 552 are shown as MSN2 sourced.
--- In smf_addin@yahoogroups.com , "Randy H" <rharmelink@...> wrote:
>
> More specifics please -- ticker symbol, element number?
>
> If they are AdvFN elements, you may need to apply the fix suggested in
> the "Links" area of the group.
>
> Or, you may be using ticker symbols that are specific to MSN.
>
> --- In smf_addin@yahoogroups.com , "shanmuk123" <shanmuk123@> wrote:
> >
> > I just joined. I get an error for any element number not associated
> with MSN...thanks
>
- 3d.
-
Re: elements from sources other than MSN
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Jan 28, 2012 6:57 pm (PST)
Most of those were obsoleted when MSN changed their web site early last
year:
2011-01-26 RCHGetElementNumber Updated the element definitions in file
smf-elements-1.txt because MSN made changes to their web pages.
-- Too many were changed to mention them all.
-- Elements #2, #541-542, #544-546, and #551-552 were obsoleted.
You'll need the new element definitions file from the "Works in Progress"
folder to pick up those elements that were redefined.
Also, see my messages from yesterday for more info:
http://finance.groups.yahoo. com/group/ smf_addin/ message/17161
http://finance.groups.yahoo. com/group/ smf_addin/ message/17162
On Sat, Jan 28, 2012 at 7:30 PM, shanmuk123 <shanmuk123@yahoo.com > wrote:
> Any ticker symbol and element number between 540 and 552 inclusive, Randy.
> On your spreadsheet that shows element number and source, elements 540 to
> 552 are shown as MSN2 sourced.
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Tidak ada komentar:
Posting Komentar