3 Messages
Digest #3300
2b
Re: RCHGetYahooQuotes returning incorrect stock Prices on weekends by "Randy Harmelink" rharmelink
Messages
Sat Jan 17, 2015 4:00 am (PST) . Posted by:
"Ian Rogers" irianr1943
The formula as stated by you is incorrect
=RCHGetTableCell("http://www.gurufocus.com/stock/&Ticker",-1,"Traded in
Other Countries")
should be
=RCHGetTableCell("http://www.gurufocus.com/stock/"&Ticker
<http://www.gurufocus.com/stock/&Ticker>,-1,"Traded in Other Countries")
Note the position of " should be at end of string and not include the
&Ticker
Ticker refers to a cell that has been Range Named as Ticker. This cell then
contains stock code eg MMM
=RCHGetTableCell("http://www.gurufocus.com/stock/&Ticker",-1,"Traded in
Other Countries")
should be
=RCHGetTableCell("http://www.gurufocus.com/stock/"&Ticker
<http://www.gurufocus.com/stock/&Ticker>,-1,"
Note the position of " should be at end of string and not include the
&Ticker
Ticker refers to a cell that has been Range Named as Ticker. This cell then
contains stock code eg MMM
Sat Jan 17, 2015 10:25 am (PST) . Posted by:
weldenc
I've noticed for the past few weekends that RCHGetYahooQuotes is returning incorrect prices on some stocks. For instance, today (Saturday) I see
Stock RCH Yahoo
SPDL .8 .59
AWLCF 11.11 10.43
EFLVF .793 .539
COCP .485 .45
My values fro RCH seem to match Yahoo during the week, but are off during the weekend. Has anyone else noticed this and is this something that can be fixed?
Stock RCH Yahoo
SPDL .8 .59
AWLCF 11.11 10.43
EFLVF .793 .539
COCP .485 .45
My values fro RCH seem to match Yahoo during the week, but are off during the weekend. Has anyone else noticed this and is this something that can be fixed?
Sat Jan 17, 2015 12:33 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Using RCHGetYahooQuotes(), I get the same prices you do from that function.
However, if I go to Yahoo using my browser (FireFox), those are the prices
I see posted on the "Summary" web page for the stock. And I tried their
"Download"; option on one stock, and got the same price as
RCHGetYahooQuotes(), so it's not an add-in issue, but a Yahoo issue.
Hmmm. Strange. When I go to the SPDL web page, it says the 0.80 "current"
quote is from Dec 5 (at 2:42 pm), but if I look at the historical quotes
web page, it says the Jan 16 price was 0.59 all day long and closed at that
price (only 200 shares traded). The other three stocks also have Dec 5
quotes shown on the "Summary" page as their most recent traded price.
Where on Yahoo did you get the 0.59 quote for SPCL?
In any case, you may need to notify Yahoo of the issue if you want it
fixed. Let them know that their "Download data (delayed)" link on their web
page is returning data from December 5th instead of the current prices.
On Sat, Jan 17, 2015 at 11:25 AM, weldencd@... wrote:
> I've noticed for the past few weekends that RCHGetYahooQuotes is
> returning incorrect prices on some stocks. For instance, today (Saturday) I
> see
>
> Stock RCH Yahoo
>
> SPDL .8 .59
>
> AWLCF 11.11 10.43
>
> EFLVF .793 .539
>
> COCP .485 .45
>
> My values fro RCH seem to match Yahoo during the week, but are off during
> the weekend. Has anyone else noticed this and is this something that can be
> fixed?
>
> __._,_
>
However, if I go to Yahoo using my browser (FireFox), those are the prices
I see posted on the "Summary" web page for the stock. And I tried their
"Download"
RCHGetYahooQuotes(
Hmmm. Strange. When I go to the SPDL web page, it says the 0.80 "current"
quote is from Dec 5 (at 2:42 pm), but if I look at the historical quotes
web page, it says the Jan 16 price was 0.59 all day long and closed at that
price (only 200 shares traded). The other three stocks also have Dec 5
quotes shown on the "Summary" page as their most recent traded price.
Where on Yahoo did you get the 0.59 quote for SPCL?
In any case, you may need to notify Yahoo of the issue if you want it
fixed. Let them know that their "Download data (delayed)" link on their web
page is returning data from December 5th instead of the current prices.
On Sat, Jan 17, 2015 at 11:25 AM, weldencd@... wrote:
> I've noticed for the past few weekends that RCHGetYahooQuotes is
> returning incorrect prices on some stocks. For instance, today (Saturday) I
> see
>
> Stock RCH Yahoo
>
> SPDL .8 .59
>
> AWLCF 11.11 10.43
>
> EFLVF .793 .539
>
> COCP .485 .45
>
> My values fro RCH seem to match Yahoo during the week, but are off during
> the weekend. Has anyone else noticed this and is this something that can be
> fixed?
>
> __._,_
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar