2 Messages
Digest #4119
Messages
Fri Aug 11, 2017 11:47 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You have two errors (well, actually three):
1. All Yahoo web page now need to be "https://" instead of "http://".
2. ">Prev Close" is no longer on the web page. It is now ">Previous Close"
3. The web page you are using no longer exists, and redirects to "
https://finance.yahoo.com/quote/TTS"
Making all three corrections, try something like:
=RCHGetTableCell("https://finance.yahoo.com/quote/"&A2,1,">Previous Close")
On Fri, Aug 11, 2017 at 7:04 PM, ruth_debardeleben@
...
wrote:
>
> Could Yahoo have broken something again since the 7-12 beta was released?
>
> Here's the problem I'm having:
>
> This formula is supposed to display the previous day's closing price, but
> is returning Error instead:
> =IF(G2,RCHGetTableCell("http://finance.yahoo.com/q?s="&A2,1,">Prev
> Close"),"")
>
> A2 is a cell that contains a ticker symbol (e.g. "TTS")
> G2 is a cell that fetches the ticker's current value (e.g. "15.20")
>
> As long as my A2 cell is blank, the formula cell is also blank. But as
> soon as I enter a ticker symbol in A2, the function returns Error.
>
> Could this have something to do with the way the yahoo finance historical
> data screens/URLs have changed this year?
>
> Do I need to use a different URL in RCHGetTableCell?
>
> Is there any other info I can provide that would help?
>
>
1. All Yahoo web page now need to be "https://" instead of "http://".
2. ">Prev Close" is no longer on the web page. It is now ">Previous Close"
3. The web page you are using no longer exists, and redirects to "
https://finance.yahoo.com/quote/TTS"
Making all three corrections, try something like:
=RCHGetTableCell("https://finance.yahoo.com/quote/"&A2,1,">Previous Close")
On Fri, Aug 11, 2017 at 7:04 PM, ruth_debardeleben@
...
wrote:
>
> Could Yahoo have broken something again since the 7-12 beta was released?
>
> Here's the problem I'm having:
>
> This formula is supposed to display the previous day's closing price, but
> is returning Error instead:
> =IF(G2,RCHGetTableCell("http://finance.yahoo.com/q?s="&A2,1,
> Close")
>
> A2 is a cell that contains a ticker symbol (e.g. "TTS"
> G2 is a cell that fetches the ticker's current value (e.g. "15.20"
>
> As long as my A2 cell is blank, the formula cell is also blank. But as
> soon as I enter a ticker symbol in A2, the function returns Error.
>
> Could this have something to do with the way the yahoo finance historical
> data screens/URLs have changed this year?
>
> Do I need to use a different URL in RCHGetTableCell?
>
> Is there any other info I can provide that would help?
>
>
Sat Aug 12, 2017 8:06 am (PDT) . Posted by:
sushiwaitress
Thank you SO MUCH!!
as a fellow techworker, I read through everything I could to try and figure it out for myself before bothering you. Let me just say The Manual is indeed very Fine.
Thank you again for all you do to support us.
Ruth
as a fellow techworker, I read through everything I could to try and figure it out for myself before bothering you. Let me just say The Manual is indeed very Fine.
Thank you again for all you do to support us.
Ruth
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar