6 Messages
Digest #3352
2a
Re: RCHgetyahoohistory for ^GSPC does not return yesterday's data by "Randy Harmelink" rharmelink
Messages
Mon Mar 9, 2015 1:21 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Feel free to address Yahoo about it...
I have no control over the data content returned by RCHGetYahooQuotes().
It's simply data that Yahoo is providing.
You can certainly retrieve your desired data directly from that web page
with RCHGetTableCell(), but it will be MUCH slower getting each data item
from individual web pages.
On Mon, Mar 9, 2015 at 1:06 PM, rjemery@... wrote:
>
> For any symbol, RCHGetYahooQuotes() needs to be overhauled to return
> values that are actually displayed on the main Yahoo Finance Page. It
> ought to be WYSIWYG. It is anything but.
>
> RCHGetYahooQuotes("SLY","y") return N/A, when the webpage shows the yield
> TTM as 1.13%. SPY returns 1.85% when the webpage shows 1.82%. The data
> returned by RCHGetYahooQuotes() are simply untrustworthy. There are too
> many instances of erroneous data, and I feel that is an issue that needs to
> be addressed promptly.
>
I have no control over the data content returned by RCHGetYahooQuotes(
It's simply data that Yahoo is providing.
You can certainly retrieve your desired data directly from that web page
with RCHGetTableCell(
from individual web pages.
On Mon, Mar 9, 2015 at 1:06 PM, rjemery@... wrote:
>
> For any symbol, RCHGetYahooQuotes(
> values that are actually displayed on the main Yahoo Finance Page. It
> ought to be WYSIWYG. It is anything but.
>
> RCHGetYahooQuotes(
> TTM as 1.13%. SPY returns 1.85% when the webpage shows 1.82%. The data
> returned by RCHGetYahooQuotes(
> many instances of erroneous data, and I feel that is an issue that needs to
> be addressed promptly.
>
Mon Mar 9, 2015 1:26 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I just tried:
=RCHGetYahooHistory("^GSPC")
...and I see data for 3/6/2015. Do you have your Internet Options set so
that you always get fresh content? Otherwise, you may be picking up an
older cached version of the file that IE has in its "Temporary Internet
Files" folder.
On Mon, Mar 9, 2015 at 1:10 PM, marco.deen@... wrote:
> If I pull RCHgetyahoohistory for ^GSPC the data for 3/6/2015 is missing.
> Other tickers and indices do not appear to have this issue. Can you verify
> this?
>
=RCHGetYahooHistory
...and I see data for 3/6/2015. Do you have your Internet Options set so
that you always get fresh content? Otherwise, you may be picking up an
older cached version of the file that IE has in its "Temporary Internet
Files" folder.
On Mon, Mar 9, 2015 at 1:10 PM, marco.deen@.
> If I pull RCHgetyahoohistory for ^GSPC the data for 3/6/2015 is missing.
> Other tickers and indices do not appear to have this issue. Can you verify
> this?
>
Mon Mar 9, 2015 2:32 pm (PDT) . Posted by:
"Marco Deen" marco.deen
I have "Every time I visit a webpage" checked under general internet
options and unchecked "allow website caches and databases"
Also restarted my computer, but still my last date for ^GSPC is 3/4/2015.
Thanks for checking on your end. Funny that it only affects ^GSPC.
Just to be safe I'll be maintaining a backup file for historical data.
On Mon, Mar 9, 2015 at 4:25 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> I just tried:
>
> =RCHGetYahooHistory("^GSPC")
>
> ...and I see data for 3/6/2015. Do you have your Internet Options set so
> that you always get fresh content? Otherwise, you may be picking up an
> older cached version of the file that IE has in its "Temporary Internet
> Files" folder.
>
> On Mon, Mar 9, 2015 at 1:10 PM, marco.deen@... wrote:
>
>> If I pull RCHgetyahoohistory for ^GSPC the data for 3/6/2015 is
>> missing. Other tickers and indices do not appear to have this issue. Can
>> you verify this?
>>
>
>
>
options and unchecked "allow website caches and databases"
Also restarted my computer, but still my last date for ^GSPC is 3/4/2015.
Thanks for checking on your end. Funny that it only affects ^GSPC.
Just to be safe I'll be maintaining a backup file for historical data.
On Mon, Mar 9, 2015 at 4:25 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> I just tried:
>
> =RCHGetYahooHistory
>
> ...and I see data for 3/6/2015. Do you have your Internet Options set so
> that you always get fresh content? Otherwise, you may be picking up an
> older cached version of the file that IE has in its "Temporary Internet
> Files" folder.
>
> On Mon, Mar 9, 2015 at 1:10 PM, marco.deen@.
>
>> If I pull RCHgetyahoohistory for ^GSPC the data for 3/6/2015 is
>> missing. Other tickers and indices do not appear to have this issue. Can
>> you verify this?
>>
>
>
>
Mon Mar 9, 2015 1:26 pm (PDT) . Posted by:
arjan.berkelaar
Sorry to bother you with this question. I am trying to download 10 year financials from Morningstar. I have a premium subscription, but when I use the template file: smfGetCSVFile-Template-MorningStar-Financials.xls http://ogres-crypt.com/SMF/Templates/smfGetCSVFile-Template-MorningStar-Financials.xls
it only downloads 5 years of data. I am logged on to Morningstar but I guess I am doing something wrong. Any help would be appreciated.
Best,
Arjan
it only downloads 5 years of data. I am logged on to Morningstar but I guess I am doing something wrong. Any help would be appreciated.
Best,
Arjan
Mon Mar 9, 2015 1:34 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You need to be logged in with the Internet Explorer browser, because the IE
security cookie needs to be created. Being logged in with something like
FIreFox or Chrome won't do the trick. If logging in with IE doesn't work,
use the EXCEL Web Query dialog (alt+d+d+w). Sometimes EXCEL is using a
different version of IE than the computer uses as a browser.
In any case, visiting morningstar.com using the EXCEL Web Query dialog is
the best way to check if you *are* logged in, based on the "Welcome"
message at the top of the page.
I just tried the template and I am getting 10 years of data.
On Mon, Mar 9, 2015 at 1:15 PM, arjan.berkelaar@... wrote:
> Sorry to bother you with this question. I am trying to download 10 year
> financials from Morningstar. I have a premium subscription, but when I use
> the template file: smfGetCSVFile-Template-MorningStar-Financials.xls
> <http://ogres-crypt.com/SMF/Templates/smfGetCSVFile-Template-MorningStar-Financials.xls>
>
> it only downloads 5 years of data. I am logged on to Morningstar but I
> guess I am doing something wrong. Any help would be appreciated.
>
security cookie needs to be created. Being logged in with something like
FIreFox or Chrome won't do the trick. If logging in with IE doesn't work,
use the EXCEL Web Query dialog (alt+d+d+w). Sometimes EXCEL is using a
different version of IE than the computer uses as a browser.
In any case, visiting morningstar.com using the EXCEL Web Query dialog is
the best way to check if you *are* logged in, based on the "Welcome"
message at the top of the page.
I just tried the template and I am getting 10 years of data.
On Mon, Mar 9, 2015 at 1:15 PM, arjan.berkelaar@... wrote:
> Sorry to bother you with this question. I am trying to download 10 year
> financials from Morningstar. I have a premium subscription, but when I use
> the template file: smfGetCSVFile-Template-MorningStar-Financials.xls
> <http://ogres-crypt.com/SMF/Templates/smfGetCSVFile-Template-MorningStar-Financials.xls>
>
> it only downloads 5 years of data. I am logged on to Morningstar but I
> guess I am doing something wrong. Any help would be appreciated.
>
Mon Mar 9, 2015 1:40 pm (PDT) . Posted by:
arjan.berkelaar
Thanks a lot Randy! I ended up using the webquery in Excel and that did the trick! Appreciate your help and all the great stuff you do!
Arjan
Arjan
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar