Selasa, 10 Maret 2015

[smf_addin] Digest Number 3352

6 Messages

Digest #3352

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.
>

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?
>

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&quot;)
>
> ...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?
>>
>
>
>

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

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.
>

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
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar