6 Messages
Digest #4092
Messages
Fri Jul 14, 2017 11:51 pm (PDT) . Posted by:
dzi6ewzrdnxj7wkxo5f6mlhps7ydjxexnjzqjzdg
Thanks a lot Randy! I changed the settings and now I'm getting the same output as you do
All the best!
Rico
All the best!
Rico
Sat Jul 15, 2017 10:12 am (PDT) . Posted by:
eremon9
Hi Randy,
Thanks again for all your hard work.
I've been unable to retrieve historical data for WFC-PL. I used to be able to get it using WFC.PL, but neither works now for either unadjusted or dividend-adjusted calls. Is there something else I need to be doing?
Tom
Thanks again for all your hard work.
I've been unable to retrieve historical data for WFC-PL. I used to be able to get it using WFC.PL, but neither works now for either unadjusted or dividend-adjusted calls. Is there something else I need to be doing?
Tom
Sat Jul 15, 2017 10:59 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
It looks like Yahoo doesn't have historical data for WFC-PL. See:
https://finance.yahoo.com/quote/WFC-PL/history
When I use smfGetYahooHistory(), I get the same one day of data I see on
that web page...
On Sat, Jul 15, 2017 at 10:12 AM, tamurphy@
...
wrote:
>
> I've been unable to retrieve historical data for WFC-PL. I used to be able
> to get it using WFC.PL, but neither works now for either unadjusted or
> dividend-adjusted calls. Is there something else I need to be doing?
>
>
>
https://finance.yahoo.com/quote/WFC-PL/history
When I use smfGetYahooHistory(
that web page...
On Sat, Jul 15, 2017 at 10:12 AM, tamurphy@
...
wrote:
>
> I've been unable to retrieve historical data for WFC-PL. I used to be able
> to get it using WFC.PL, but neither works now for either unadjusted or
> dividend-adjusted calls. Is there something else I need to be doing?
>
>
>
Sat Jul 15, 2017 1:19 pm (PDT) . Posted by:
eadamy
I've looked at quite a number of services, free and paid. I require dividend adjusted close data which some may not require but it's harder to come by.
Quandl offers free downloadable company price history from Wiki. I tried their Quote Media service for a month and found dozens of errors in just 20+- ETFs I tracked. Worse, QM was unresponsive after I sent them a detailed list of errors. Other services I checked, which offer adjusted close data were very expensive and many are institutional only.
I ended up building a QuoteServer to obtain and serve data from multiple sources and maintain my own dividend history for a limited number of ETFs. I have long been a Norgate subscriber for my chart work so I use them as my primary source of exchange data. I export that data to Ascii and then process against the dividend database to create adjusted close for 30+- ETFs and OEFs. Y remains my backup for adhoc needs; however I carefully check each symbol I use.
Earl
Quandl offers free downloadable company price history from Wiki. I tried their Quote Media service for a month and found dozens of errors in just 20+- ETFs I tracked. Worse, QM was unresponsive after I sent them a detailed list of errors. Other services I checked, which offer adjusted close data were very expensive and many are institutional only.
I ended up building a QuoteServer to obtain and serve data from multiple sources and maintain my own dividend history for a limited number of ETFs. I have long been a Norgate subscriber for my chart work so I use them as my primary source of exchange data. I export that data to Ascii and then process against the dividend database to create adjusted close for 30+- ETFs and OEFs. Y remains my backup for adhoc needs; however I carefully check each symbol I use.
Earl
Sat Jul 15, 2017 3:10 pm (PDT) . Posted by:
vkleniko
Randy - any known reason why your =smfGetCSVFile("http://www.gurufocus.com/download_financials_in_CSV.php?symbol="&TICKER) method has stopped pulling data from GuruFocus? I now get blank cells. Sorry if I may have missed a thread with that same issue already addressed. Vlad
Sat Jul 15, 2017 3:54 pm (PDT) . Posted by:
vkleniko
Randy - never mind! just saw in xla change log the required change to https protocol for Guru's call functions. Kind regards and thanks again for the enormous effort! Vlad
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar