Senin, 14 Agustus 2017

[smf_addin] Digest Number 4121

6 Messages

Digest #4121

Messages

Sun Aug 13, 2017 8:09 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

FYI -- I just uploaded beta version 2017.08.13 of the add-in with the
GuruFocus changes...

On Sun, Aug 13, 2017 at 5:51 PM, danseiler2000@
​...
wrote:

>
> I don't know what happened, I have been using smfGetGuruFocusItem() for a
> long time. However, it has not worked in a while.
>
> =RCHGetElementNumber("Version") will return "Stock Market Functions
> add-in, Version 2.1.2017.07.12 (C:\SMF; Windows (32-bit) NT 6.02; 14.0; ; ;
> 1)"
>
> I have verified that I am logged in by making an external web data query.
>
> What could be wrong?
>

Mon Aug 14, 2017 4:31 am (PDT) . Posted by:

gz_cp

Hi Randy,

Does the smfGetCSVFile able to get Yahoo adjusted price history in CSV?
We can only use smfGetYahooHistory in he beta to obtain Yahoo data?


Thanks.



Mon Aug 14, 2017 9:04 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

​You cannot use smfGetCSVFile() to get the historical quotes CSV file from
Yahoo because it requires both a cookie and a crumb URL parameter to access
the files.

On Mon, Aug 14, 2017 at 4:31 AM, gz_cp@
​...
wrote:

>
> Does the smfGetCSVFile able to get Yahoo adjusted price history in CSV?
> We can only use smfGetYahooHistory in he beta to obtain Yahoo data?
>
>
>

Mon Aug 14, 2017 8:15 am (PDT) . Posted by:

lapub1

Thanks Randy that worked great!

Elliot.

Mon Aug 14, 2017 9:05 am (PDT) . Posted by:

stocks32@hotmail.com

I am looking for 10 year historical financial data. In the past, I was able to get it from MSN. Now, I need a better solution. I am also looking for Market Cap, Shares Outstanding, and historical dividend data.
Will the add-in provide this type of data?
If so, how do I get started?
Thanks for your time.

Mon Aug 14, 2017 10:55 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Normally, I would suggest either GuruFocus or MorningStar for historical
financial data, but they require membership to get 10 years of financial
data. You could go to AdvFN, but I haven't used them in the last few years
because the data was getting to be out-of-date and not trustworthy. Check
the templates web page.

Market cap, shares outstanding, and historical dividend data are all
available with defined elements. Check out the XLS documentation that was
in the ZIP archive of the add-in.

On Mon, Aug 14, 2017 at 8:58 AM, stocks32@
​...
wrote:

> I am looking for 10 year historical financial data. In the past, I was
> able to get it from MSN. Now, I need a better solution. I am also
> looking for Market Cap, Shares Outstanding, and historical dividend data.
>
> Will the add-in provide this type of data?
>
> If so, how do I get started?
>
> Thanks for your time.
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar