Senin, 21 September 2015

[smf_addin] Digest Number 3518

5 Messages

Digest #3518

Messages

Sun Sep 20, 2015 7:48 am (PDT) . Posted by:

jchealey66

Ok no problem will do that.

Many thanks for your reply.

Much appreciated,
Regards,
James

Sun Sep 20, 2015 7:50 am (PDT) . Posted by:

jchealey66

Brilliant. Thanks for letting me know,

Regards,
James

Sun Sep 20, 2015 7:51 am (PDT) . Posted by:

jchealey66

Brilliant. Thanks for letting me know,

Regards,
James

Sun Sep 20, 2015 10:57 am (PDT) . Posted by:

gotsaurabh

Is there an alternative pricing source I could use where I don't have to worry about this? Yahoo Finance's behavior is a bit of an oddball here.

Sun Sep 20, 2015 1:00 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

You can get it from MorningStar (adjusted for splits only?) with something
like:

=INDEX(smfGetCSVFile("
http://performance.morningstar.com/Performance/stock/exportStockPrice.action?pd=custom&freq=d&sd=09/14/2015&ed=09/14/2015&t=MMM
",,3,5),3,5)

Or, from Google (adjusted for splits only?), with something like:

=smfConvertData(smfGetTagContent("
https://www.google.com/finance/historical?&startdate=Sep+14%2C+2015&enddate=Sep+14%2C+2015&q=MMM
","td",5,">Date","<tr"))

...or:

=INDEX(smfGetCSVFile("
http://www.google.com/finance/historical?startdate=Sep+14%2C+2015&enddate=Sep+14%2C+2015&q=MMM&output=csv
",,2,5),2,5)

On Sun, Sep 20, 2015 at 10:57 AM, gotsaurabh@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Is there an alternative pricing source I could use where I don't have to
> worry about this? Yahoo Finance's behavior is a bit of an oddball here.
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar