4 Messages
Digest #4150
Messages
Tue Sep 19, 2017 11:13 am (PDT) . Posted by:
lewglenn
Randy,
Can you tell me where to find the latest version of smfGetYahooHistory and the documentation that goes with it?
Thanks.
Can you tell me where to find the latest version of smfGetYahooHistory and the documentation that goes with it?
Thanks.
Tue Sep 19, 2017 12:08 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The newly released ZIP file would have the most recent version of
everything.
At the moment, the only documentation of function parameters is here:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32114
On Tue, Sep 19, 2017 at 11:13 AM, lewglenn@
...
wrote:
>
> Can you tell me where to find the latest version of smfGetYahooHistory
> and the documentation that goes with it?
>
>
everything.
At the moment, the only documentation of function parameters is here:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32114
On Tue, Sep 19, 2017 at 11:13 AM, lewglenn@
...
wrote:
>
> Can you tell me where to find the latest version of smfGetYahooHistory
> and the documentation that goes with it?
>
>
Tue Sep 19, 2017 4:21 pm (PDT) . Posted by:
lewglenn
The documentation says the start date defaults to a year ago but when I use:
Range("A1:B20000") = smfGetYahooHistory("IEF", , , "d", "dc", , 1, 20000, 2)
I get a start date of 7/30/2002. Am I doing something wrong?
Range("
I get a start date of 7/30/2002. Am I doing something wrong?
Tue Sep 19, 2017 5:03 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Sorry, the documentation is not up-to-date. You're not doing anything wrong.
On May 21st, I changed the default starting date to be 1/1/1970. That's so
if you do multiple requests against the same equity, it can reuse the
already retrieved data, because the URL will be the same. The current
design is based on allowing minimal parameters (especially in VBA usage).
In my testing, I found that the overhead in getting data between a small
range of dates vs back to 1970 was minimal, so I decided that it could be a
way to reduce the number of Internet requests.
Hmm. Maybe I should make the same change to smfPricesByDates() and
smfPricesBetween, so that using them multiple times against the same ticker
symbol will result in only one Internet access.
You could use something like this streamlined version of the VBA code:
Range("B1:C20000") = smfGetYahooHistory("IEF", pItems:="dc")
...which just gets the last 20000 days of history, if available.
On Tue, Sep 19, 2017 at 4:21 PM, lewglenn@
...
wrote:
>
> The documentation says the start date defaults to a year ago but when I
> use:
>
>
> Range("A1:B20000") = smfGetYahooHistory("IEF", , , "d", "dc", , 1, 20000,
> 2)
>
> I get a start date of 7/30/2002. Am I doing something wrong?
>
On May 21st, I changed the default starting date to be 1/1/1970. That's so
if you do multiple requests against the same equity, it can reuse the
already retrieved data, because the URL will be the same. The current
design is based on allowing minimal parameters (especially in VBA usage).
In my testing, I found that the overhead in getting data between a small
range of dates vs back to 1970 was minimal, so I decided that it could be a
way to reduce the number of Internet requests.
Hmm. Maybe I should make the same change to smfPricesByDates(
smfPricesBetween, so that using them multiple times against the same ticker
symbol will result in only one Internet access.
You could use something like this streamlined version of the VBA code:
Range("
...which just gets the last 20000 days of history, if available.
On Tue, Sep 19, 2017 at 4:21 PM, lewglenn@
...
wrote:
>
> The documentation says the start date defaults to a year ago but when I
> use:
>
>
> Range("
> 2)
>
> I get a start date of 7/30/2002. Am I doing something wrong?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar