3 Messages
Digest #4033
Messages
Thu May 25, 2017 6:48 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I just used:
=MAX(smfGetYahooHistory("KSS","5/1/2017","5/25/2017",,"c",,,50,1))
The "50,1" just makes sure I have enough rows to hold the data (too many is
OK). If the date range were wider, it would need to be increased. If your
parameters were in cells, you could just subtract the dates, as in:
=MAX(smfGetYahooHistory(B6,C6,D6,,"c",,,D6-C6,1))
On Thu, May 25, 2017 at 5:51 PM, tmallen2@
...wrote:
>
> I've been following all the changes lately. I also have the latest beta
> version of 5/25/17 I believe.
>
> One parameter I can't seem to figure out is finding the highest close for
> a single stock between dates.
>
> I used to use RCHGetYahooHistory for this.
>
> I don't think it works with the new smfGetYahooHistory function.
>
> How would I find the highest close for lets say:
>
> KSS
>
> Between dates 5/9/17 and 5/25/17.
>
> The result should be: $40.32 on 5/10/17.
>
> It could be the adjusted close number.
>
>
>
>
>
=MAX(smfGetYahooHis
The "50,1" just makes sure I have enough rows to hold the data (too many is
OK). If the date range were wider, it would need to be increased. If your
parameters were in cells, you could just subtract the dates, as in:
=MAX(smfGetYahooHis
On Thu, May 25, 2017 at 5:51 PM, tmallen2@
...wrote:
>
> I've been following all the changes lately. I also have the latest beta
> version of 5/25/17 I believe.
>
> One parameter I can't seem to figure out is finding the highest close for
> a single stock between dates.
>
> I used to use RCHGetYahooHistory for this.
>
> I don't think it works with the new smfGetYahooHistory function.
>
> How would I find the highest close for lets say:
>
> KSS
>
> Between dates 5/9/17 and 5/25/17.
>
> The result should be: $40.32 on 5/10/17.
>
> It could be the adjusted close number.
>
>
>
>
>
Thu May 25, 2017 7:12 pm (PDT) . Posted by:
jpaulaustin
Randy,
Are you getting a proper "adjusted close"? I seem to only get the "close" without any adjustments for dividends.
Paul
On Thu, May 25, 2017 at 9:48 PM -0400, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
I just used:
=MAX(smfGetYahooHistory("KSS","5/1/2017","5/25/2017",,"c",,,50,1))
The "50,1" just makes sure I have enough rows to hold the data (too many is OK). If the date range were wider, it would need to be increased. If your parameters were in cells, you could just subtract the dates, as in:
=MAX(smfGetYahooHistory(B6,C6,D6,,"c",,,D6-C6,1))
On Thu, May 25, 2017 at 5:51 PM, tmallen2@...wrote:
I've been following all the changes lately. I also have the latest beta version of 5/25/17 I believe.
One parameter I can't seem to figure out is finding the highest close for a single stock between dates.
I used to use RCHGetYahooHistory for this.
I don't think it works with the new smfGetYahooHistory function.
How would I find the highest close for lets say:
KSS
Between dates 5/9/17 and 5/25/17.
The result should be: $40.32 on 5/10/17.
It could be the adjusted close number.
Are you getting a proper "adjusted close"? I seem to only get the "close" without any adjustments for dividends.
Paul
On Thu, May 25, 2017 at 9:48 PM -0400, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
I just used:
=MAX(smfGetYahooHis
The "50,1" just makes sure I have enough rows to hold the data (too many is OK). If the date range were wider, it would need to be increased. If your parameters were in cells, you could just subtract the dates, as in:
=MAX(smfGetYahooHis
On Thu, May 25, 2017 at 5:51 PM, tmallen2@...wrote:
I've been following all the changes lately. I also have the latest beta version of 5/25/17 I believe.
One parameter I can't seem to figure out is finding the highest close for a single stock between dates.
I used to use RCHGetYahooHistory for this.
I don't think it works with the new smfGetYahooHistory function.
How would I find the highest close for lets say:
KSS
Between dates 5/9/17 and 5/25/17.
The result should be: $40.32 on 5/10/17.
It could be the adjusted close number.
Thu May 25, 2017 7:20 pm (PDT) . Posted by:
ridgebacksexcel
So I need to have as many rows as days in the date range correct?
This formula should work.
Thanks.
This formula should work.
Thanks.
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar