3 Messages
Digest #4039
Messages
Sun May 28, 2017 5:03 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
All of these return the same value to me, under version 2017.05.25:
=AVERAGE(smfGetYahooHistory("MMM",,,,"c",0,,50,1))
=AVERAGE(RCHGetYahooHistory("MMM",,,,,,,,"a",0,,,50,1))
=AVERAGE(RCHGetYahooHistory("MMM",,,,,,,,"c",0,,,50,1))
On Sun, May 28, 2017 at 3:19 PM, lewglenn@
...> wrote:
>
> I'm trying to get the 50-day moving average with the new
> smfGetYahooHistory call; my code looks like:
>
> 'Now reset 50-day SMA because above call uses 50 calendar days rather than
> market days
> For r = 2 To rowmax
> If IsEmpty(Cells(r, "P")) Then
> Res = Cells(r, "A")
> ' Cells(r, "I") = Application.WorksheetFunction.
> Average(RCHGetYahooHistory(Res, , , , , , , , "a", 0, , , 50, 1))
> Cells(r, "I") = Application.WorksheetFunction.
> Average(smfGetYahooHistory(Res, , , "d", "dc", , 1, 50, 1))
> End If
> Next r
>
> The old RCHGetYahooHistory call is commented out but this loop worked fine
> when it was operable. I'm attempting to emulate this call with the new
> smfGetYahooHistory call but I must have some of the arguments wrong because
> I 'm getting nonsense for the 50-day moving average in column "I" the way
> I'm using the new call. Can you please correct my error?
>
>
=AVERAGE(smfGetYaho
=AVERAGE(RCHGetYaho
=AVERAGE(RCHGetYaho
On Sun, May 28, 2017 at 3:19 PM, lewglenn@
...> wrote:
>
> I'm trying to get the 50-day moving average with the new
> smfGetYahooHistory call; my code looks like:
>
> 'Now reset 50-day SMA because above call uses 50 calendar days rather than
> market days
> For r = 2 To rowmax
> If IsEmpty(Cells(
> Res = Cells(r, "A"
> ' Cells(r, "I"
> Average(RCHGetYahoo
> Cells(r, "I"
> Average(smfGetYahoo
> End If
> Next r
>
> The old RCHGetYahooHistory call is commented out but this loop worked fine
> when it was operable. I'm attempting to emulate this call with the new
> smfGetYahooHistory call but I must have some of the arguments wrong because
> I 'm getting nonsense for the 50-day moving average in column "I" the way
> I'm using the new call. Can you please correct my error?
>
>
Sun May 28, 2017 6:56 pm (PDT) . Posted by:
bamzoomalice
Hello Randy,
I am waiting patiently (and hopeful) for the new version of smf_getyahoohistory to become available. Seeing Yahoo could become a less and less reliable as a data source, is there any alternative sources to get historical prices? I did notice that Google has historical prices but do not see it as an element in smf-elements-3.
Also, do you know of any paid services offering similar functionality should this be the end of the road for historical prices? :(
Thanks
Jason
I am waiting patiently (and hopeful) for the new version of smf_getyahoohistory to become available. Seeing Yahoo could become a less and less reliable as a data source, is there any alternative sources to get historical prices? I did notice that Google has historical prices but do not see it as an element in smf-elements-
Also, do you know of any paid services offering similar functionality should this be the end of the road for historical prices? :(
Thanks
Jason
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar