3 Messages
Digest #4467
Messages
Tue Jan 22, 2019 12:43 pm (PST) . Posted by:
iroc158
First query = "--" Second query blanks, try again and a msg box appears *** Unable to Open, Can not download the information you requested***. Forgot to mention I had changed the VBA code to HTTPS://query1.finance.yahoo.com before asking for help, in an attempt to see if that would make things work.
I traced the problem to this: Excel 2000 using IE 6.0 routines to pull the data. Yahoo had to have done something recently, so that the IE 6.0 routines no longer work, but of course, Firefox works when the second query is entered into the address bar, but you can't force Excel to use FF routines instead!
I'm going to have to finally update to an newer version of Excel ....
Thank you very much for your time Randy, and for the hard work you've put into the SMF add-in in general! Fantastic VBA code too!!
I traced the problem to this: Excel 2000 using IE 6.0 routines to pull the data. Yahoo had to have done something recently, so that the IE 6.0 routines no longer work, but of course, Firefox works when the second query is entered into the address bar, but you can't force Excel to use FF routines instead!
I'm going to have to finally update to an newer version of Excel ....
Thank you very much for your time Randy, and for the hard work you've put into the SMF add-in in general! Fantastic VBA code too!!
Tue Jan 22, 2019 4:26 pm (PST) . Posted by:
bobc94595
Randy,
Currently trying to resurrect an old form.
Able to get Date of Next Divy using DATEVALUE(RCHGetTableCell("https://finance.yahoo.com/q/ks?s="&C7&"+Key+Statistics",1,">Dividends &",">Ex-Dividend Date"))
Cannot get Date of Last Divy using DATEVALUE(RCHGetTableCell("https://finance.yahoo.com/q/hp?a=00&b=5&c=1988&d=11&e=27&f=2020&g=v&s="&C7,1,">Prices<",">Date<",,,1))
Currently trying to resurrect an old form.
Able to get Date of Next Divy using DATEVALUE(RCHGetTableCell("https://finance.yahoo.com/q/ks?s="&C7&"+Key+Statistics",1,">Dividends &",">Ex-Dividend Date"))
Cannot get Date of Last Divy using DATEVALUE(RCHGetTableCell("https://finance.yahoo.com/q/hp?a=00&b=5&c=1988&d=11&e=27&f=2020&g=v&s="&C7,1,
Wed Jan 23, 2019 12:37 am (PST) . Posted by:
"Randy Harmelink" rharmelink
The delivered source code of the Yahoo historical quotes web page no longer
contains a table of historical quotes. It's built dynamically from JSON
data.
I use something like this formula to get the most recent ex-dividend date:
=smfGetYahooHistory("MMM",,,"v",,0)
On Tue, Jan 22, 2019 at 5:26 PM conlonrc@... wrote:
>
> Currently trying to resurrect an old form.
>
> Able to get Date of Next Divy using DATEVALUE(RCHGetTableCell("
> https://finance.yahoo.com/q/ks?s="&C7&"+Key+Statistics",1,">Dividends
> &",">Ex-Dividend Date"))
>
> Cannot get Date of Last Divy using DATEVALUE(RCHGetTableCell("
> https://finance.yahoo.com/q/hp?a=00&b=5&c=1988&d=11&e=27&f=2020&g=v&s=
> "&C7,1,">Prices<",">Date<",,,1))
>
>
>
contains a table of historical quotes. It's built dynamically from JSON
data.
I use something like this formula to get the most recent ex-dividend date:
=smfGetYahooHistory("MMM",,,"v",,0)
On Tue, Jan 22, 2019 at 5:26 PM conlonrc@... wrote:
>
> Currently trying to resurrect an old form.
>
> Able to get Date of Next Divy using DATEVALUE(RCHGetTableCell("
> https://finance.yahoo.com/q/ks?s="&C7&"+Key+Statistics",1,">Dividends
> &",">Ex-Dividend Date"))
>
> Cannot get Date of Last Divy using DATEVALUE(RCHGetTableCell("
> https://finance.yahoo.com/q/hp?a=00&b=5&c=1988&d=11&e=27&f=2020&g=v&s=
> "&C7,1,
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar