4 Messages
Digest #4048
Messages
Sat Jun 3, 2017 6:36 am (PDT) . Posted by:
krisha_mehta
Thanks Randy, a tons.You rock! Waiting for a final release.
I use smfPricesByDates a lot..
I downloaded the beta version it all works now and is backward compatible. I didn't have to change any code. It is lot slower..I use this formula across an array of about 100 stocks {= (smfPricesByDates(A14,NOW()-1) - smfPricesByDates(A14,N$5:P$5))/ smfPricesByDates(A14, N$5:P$5)}
N$5:P$5 has values for 1, 5 and 10 years respectively.
I use this to calculate 1 yr, 5 yr, 10 yr returns based on Now(). Any other suggestions
I use smfPricesByDates a lot..
I downloaded the beta version it all works now and is backward compatible. I didn't have to change any code. It is lot slower..I use this formula across an array of about 100 stocks {= (smfPricesByDates(
N$5:P$5 has values for 1, 5 and 10 years respectively.
I use this to calculate 1 yr, 5 yr, 10 yr returns based on Now(). Any other suggestions
Sat Jun 3, 2017 11:07 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Two issues:
1. The new method of getting historical quotes from Yahoo is slower than
before, and you are calling the process twice in that function. You should
either get all four prices at once and compute the returns, or retrieve the
current price with RCHGetYahooQuotes(). Or, if you have a cell with the
current price in it, just do:
=M14/smfPricesByDates(A14, N$5:P$5)-1
2. Using NOW() in your function makes it volatile. That means it will
recalculate EVERY time you make a change in the workbook. Even entering a
simple value in an unrelated cell. Another reason to use
RCHGetYahooQuotes() -- to get the current value. If I need the "current"
date, I usually use this in a cell so I can refer to it and not make
anything volatile:
=DATEVALUE(RCHGetYahooQuotes("SPY","d1"))
On Sat, Jun 3, 2017 at 6:36 AM, krisha_mehta@ <krisha_mehta@yahoo.com>
.. wr
ote:
>
> I use smfPricesByDates a lot..
> I downloaded the beta version it all works now and is backward compatible.
> I didn't have to change any code. It is lot slower..I use this formula
> across an array of about 100 stocks
> {
>
> =
>
> (smfPricesByDates(A14,NOW()-1) - smfPricesByDates(A14,N$5:P$5))/
> smfPricesByDates(A14, N$5:P$5)}
>
> N$5:P$5 has values for 1, 5 and 10 years respectively.
>
> I use this to calculate 1 yr, 5 yr, 10 yr returns based on Now(). Any
> other suggestions
>
>
1. The new method of getting historical quotes from Yahoo is slower than
before, and you are calling the process twice in that function. You should
either get all four prices at once and compute the returns, or retrieve the
current price with RCHGetYahooQuotes(). Or, if you have a cell with the
current price in it, just do:
=M14/smfPricesByDates(A14, N$5:P$5)-1
2. Using NOW() in your function makes it volatile. That means it will
recalculate EVERY time you make a change in the workbook. Even entering a
simple value in an unrelated cell. Another reason to use
RCHGetYahooQuotes() -- to get the current value. If I need the "current"
date, I usually use this in a cell so I can refer to it and not make
anything volatile:
=DATEVALUE(RCHGetYahooQuotes("SPY","d1"))
On Sat, Jun 3, 2017 at 6:36 AM, krisha_mehta@ <krisha_mehta@yahoo.com>
.. wr
ote:
>
> I use smfPricesByDates a lot..
> I downloaded the beta version it all works now and is backward compatible.
> I didn't have to change any code. It is lot slower..I use this formula
> across an array of about 100 stocks
> {
>
> =
>
> (smfPricesByDates(
> smfPricesByDates(
>
> N$5:P$5 has values for 1, 5 and 10 years respectively.
>
> I use this to calculate 1 yr, 5 yr, 10 yr returns based on Now(). Any
> other suggestions
>
>
Sat Jun 3, 2017 8:37 am (PDT) . Posted by:
rjemery7
Where is the latest beta add-in file located? I am unable to find it. Please be specific.
Sat Jun 3, 2017 10:48 am (PDT) . Posted by:
"Randy Randall" randyr_cds
See
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32375
On Sat, Jun 3, 2017 at 11:37 AM, rjemery@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
>
> Where is the latest beta add-in file located? I am unable to find it.
> Please be specific.
>
>
>
>
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32375
On Sat, Jun 3, 2017 at 11:37 AM, rjemery@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
>
> Where is the latest beta add-in file located? I am unable to find it.
> Please be specific.
>
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar