6 Messages
Digest #3719
Messages
Fri Jun 3, 2016 5:00 am (PDT) . Posted by:
sirons1962
I have the latest elements installed. I went back the the site to download the workbook, used MMM and IBM and it still comes up with Errors only in the Cash Flow Ratios section.
I then re-downloaded smf-elements-4 and tried them again with the same results.
Puzzling.
I then re-downloaded smf-elements-
Puzzling.
Fri Jun 3, 2016 5:34 am (PDT) . Posted by:
sirons1962
I went back in and deleted the smf-elements-4 file, re-downloaded it and now it is working. Not sure why it wasn't before.
Thanks.
Thanks.
Fri Jun 3, 2016 12:52 pm (PDT) . Posted by:
ridgebacksexcel
Randy,
I searched your forum looking for this answer but I am not sure I understand the exact format.
What is the easiest way to find the highest quote between two dates for lets say for "INTC"?
In the example I want to use the date 1/6/2014 and Today().
I am trying to use: =smfPricesByDates("INTC",Date(2014,1,6),Today())
I noticed some examples that showed: =smfPricesByDates("INTC",Date(2016,1,4),Today(),,"H",0)
Not sure what the 'H" and 0 mean and it does not show in the documentation.
I just want to make sure the result I am getting is the correct one.
I get: $23.54 which seems to be the adjusted close for the date 1/6/2014.
Thanks.
I searched your forum looking for this answer but I am not sure I understand the exact format.
What is the easiest way to find the highest quote between two dates for lets say for "INTC"
In the example I want to use the date 1/6/2014 and Today().
I am trying to use: =smfPricesByDates(
I noticed some examples that showed: =smfPricesByDates(
Not sure what the 'H" and 0 mean and it does not show in the documentation.
I just want to make sure the result I am getting is the correct one.
I get: $23.54 which seems to be the adjusted close for the date 1/6/2014.
Thanks.
Fri Jun 3, 2016 12:57 pm (PDT) . Posted by:
ridgebacksexcel
I manually searched the historical data for those dates for INTC. I came up with $37.90 for the highest high quote between today and 1/6/2014.
So I guess that is the answer I am looking for the formula to give unless I missed a higher quote.
So I guess that is the answer I am looking for the formula to give unless I missed a higher quote.
Fri Jun 3, 2016 1:49 pm (PDT) . Posted by:
ridgebacksexcel
Actually I found one big error. I am using the smfPricesByDates function instead of the smfPricesBetween function.
I shortened the search date to compare the results to one page on Yahoo's historical prices.
This is the function I am trying now: =smfPricesBetween("INTC",DATE(2016,3,1),TODAY(),"04")
This returns $32.47
I am trying to figure out how it gets that result and from where on the page.
The date search: =smfPricesBetween("INTC",DATE(2016,3,1),TODAY(),"03") returns 3/30/16.
I am looking at that date and the high price is: $32.75 and the adj. close price is: $32.43.
I am looking for the high result on 3/30/16 of $32.75. If that is not possible then the highest close price of $32.43 on 3/30/16.
Maybe the price is adjusted for the .26 dividend but the math seems a bit off.
Just looking for a little clarity.
Thanks.
I shortened the search date to compare the results to one page on Yahoo's historical prices.
This is the function I am trying now: =smfPricesBetween(
This returns $32.47
I am trying to figure out how it gets that result and from where on the page.
The date search: =smfPricesBetween(
I am looking at that date and the high price is: $32.75 and the adj. close price is: $32.43.
I am looking for the high result on 3/30/16 of $32.75. If that is not possible then the highest close price of $32.43 on 3/30/16.
Maybe the price is adjusted for the .26 dividend but the math seems a bit off.
Just looking for a little clarity.
Thanks.
Fri Jun 3, 2016 8:23 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Responses below:
On Fri, Jun 3, 2016 at 12:52 PM, tmallen2@bellsouth.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I searched your forum looking for this answer but I am not sure I
> understand the exact format.
>
> What is the easiest way to find the highest quote between two dates for
> lets say for "INTC"?
>
Should be:
=smfPricesBetween("INTC",DATE(2016,3,1),DATE(2016,6,3),"04")
Another option would be:
=MAX(RCHGetYahooHistory("INTC",2016,3,3,2016,6,3,,"H",0,1,,200,1))
In the example I want to use the date 1/6/2014 and Today().
>
Tip -- Not a good idea to use TODAY() in a situation like this. TODAY() is
a volatile function, so using it makes your formula volatile. That means
any time you change something in the workbook, it will recalculate. It can
be very frustrating to wait for all the volatile formulas to recalculate,
even though all you did was change a heading or a label.
Instead, what I do is retrieve the last trading date of SPY:
=DateValue(RCHGetYahooQuotes("SPY","d1"))
...and then refer to that cell every time I want the latest date the market
was open. You can even assign a name to the cell so it's self-documenting.
> I am trying to use: =smfPricesByDates("INTC",Date(2014,1,6),Today())
>
> I noticed some examples that showed: =
>
> smfPricesByDates("INTC",Date(2016,1,4),Today(),,"H",0)
>
> Not sure what the 'H" and 0 mean and it does not show in the documentation.
>
Wrong function. That returns adjusted closing prices for a number of dates.
I don't know where you found the example with the "H" and 0, but they would
be meaningless. The function only has parameters for ticker symbol and one
or more dates and/or ranges of dates.
> I just want to make sure the result I am getting is the correct one.
>
> I get: $23.54 which seems to be the adjusted close for the date 1/6/2014.
>
For me, this:
=smfPricesByDates("INTC",DATE(2016,1,4),TODAY(),,"H",0)
...returns:
$33.40 $31.62
...which is what I would expect, since the adjusted closing prices for two
dates were requested. The "H" and 0 are just ignored as they aren't dates.
On Fri, Jun 3, 2016 at 12:57 PM, tmallen2@bellsouth.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I manually searched the historical data for those dates for INTC. I came
> up with $37.90 for the highest high quote between today and 1/6/2014.
>
> So I guess that is the answer I am looking for the formula to give unless
> I missed a higher quote.
>
$37.90 is an unadjusted high. smfPricesBetween() is only for adjusted
prices, and should return $36.1595969922884..
On Fri, Jun 3, 2016 at 1:49 PM, tmallen2@bellsouth.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Actually I found one big error. I am using the smfPricesByDates function
> instead of the smfPricesBetween function.
>
Yup.
> I shortened the search date to compare the results to one page on Yahoo's
> historical prices.
>
> This is the function I am trying now: =
>
> smfPricesBetween("INTC",DATE(2016,3,1),TODAY(),"04")
>
> This returns $32.47
>
Yup.
I am trying to figure out how it gets that result and from where on the
> page.
>
> The date search: =smfPricesBetween("INTC",DATE(2016,3,1),TODAY(),"03")
> returns 3/30/16.
>
> I am looking at that date and the high price is: $32.75 and the adj. close
> price is: $32.43.
>
Yup. And $32.4695334368552 is the adjusted high price for that day.
I am looking for the high result on 3/30/16 of $32.75. If that is not
> possible then the highest close price of $32.43 on 3/30/16.
>
Then you need to use the RCHGetYahooHistory() function and do it yourself.
None of my derivative functions use unadjusted prices, because they don't
make sense in the context of a period of time.
*Why in the world would you want an unadjusted high price from within a
range of dates?*
As an illustration of why that makes no sense, look at what happens if a
1:10 or 3:1 stock split takes place. Would you WANT the 1:10 stock split to
CREATE a high price within a date range?
Or a 3:1 stock split prevent new highs from being achieved for a long
time to come?
Maybe the price is adjusted for the .26 dividend but the math seems a bit
> off.
>
Adjusted high price for 3/30 = Unadjusted high * Adjusted close /
Unadjusted close = $32.75 * $32.429875 / $32.71 = $32.4695324442067
> Just looking for a little clarity.
>
>
Hope that helped.
On Fri, Jun 3, 2016 at 12:52 PM, tmallen2@bellsouth.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I searched your forum looking for this answer but I am not sure I
> understand the exact format.
>
> What is the easiest way to find the highest quote between two dates for
> lets say for "INTC"?
>
Should be:
=smfPricesBetween("INTC",DATE(2016,3,1),DATE(2016,6,3),"04")
Another option would be:
=MAX(RCHGetYahooHistory("INTC",2016,3,3,2016,6,3,,"H",0,1,,200,1))
In the example I want to use the date 1/6/2014 and Today().
>
Tip -- Not a good idea to use TODAY() in a situation like this. TODAY() is
a volatile function, so using it makes your formula volatile. That means
any time you change something in the workbook, it will recalculate. It can
be very frustrating to wait for all the volatile formulas to recalculate,
even though all you did was change a heading or a label.
Instead, what I do is retrieve the last trading date of SPY:
=DateValue(RCHGetYahooQuotes("SPY","d1"))
...and then refer to that cell every time I want the latest date the market
was open. You can even assign a name to the cell so it's self-documenting.
> I am trying to use: =smfPricesByDates("INTC",Date(2014,1,6),Today())
>
> I noticed some examples that showed: =
>
> smfPricesByDates("INTC",Date(2016,1,4),Today(),,"H",0)
>
> Not sure what the 'H" and 0 mean and it does not show in the documentation.
>
Wrong function. That returns adjusted closing prices for a number of dates.
I don't know where you found the example with the "H" and 0, but they would
be meaningless. The function only has parameters for ticker symbol and one
or more dates and/or ranges of dates.
> I just want to make sure the result I am getting is the correct one.
>
> I get: $23.54 which seems to be the adjusted close for the date 1/6/2014.
>
For me, this:
=smfPricesByDates("INTC",DATE(2016,1,4),TODAY(),,"H",0)
...returns:
$33.40 $31.62
...which is what I would expect, since the adjusted closing prices for two
dates were requested. The "H" and 0 are just ignored as they aren't dates.
On Fri, Jun 3, 2016 at 12:57 PM, tmallen2@bellsouth.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I manually searched the historical data for those dates for INTC. I came
> up with $37.90 for the highest high quote between today and 1/6/2014.
>
> So I guess that is the answer I am looking for the formula to give unless
> I missed a higher quote.
>
$37.90 is an unadjusted high. smfPricesBetween() is only for adjusted
prices, and should return $36.1595969922884..
On Fri, Jun 3, 2016 at 1:49 PM, tmallen2@bellsouth.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Actually I found one big error. I am using the smfPricesByDates function
> instead of the smfPricesBetween function.
>
Yup.
> I shortened the search date to compare the results to one page on Yahoo's
> historical prices.
>
> This is the function I am trying now: =
>
> smfPricesBetween(
>
> This returns $32.47
>
Yup.
I am trying to figure out how it gets that result and from where on the
> page.
>
> The date search: =smfPricesBetween(
> returns 3/30/16.
>
> I am looking at that date and the high price is: $32.75 and the adj. close
> price is: $32.43.
>
Yup. And $32.4695334368552 is the adjusted high price for that day.
I am looking for the high result on 3/30/16 of $32.75. If that is not
> possible then the highest close price of $32.43 on 3/30/16.
>
Then you need to use the RCHGetYahooHistory(
None of my derivative functions use unadjusted prices, because they don't
make sense in the context of a period of time.
*Why in the world would you want an unadjusted high price from within a
range of dates?*
As an illustration of why that makes no sense, look at what happens if a
1:10 or 3:1 stock split takes place. Would you WANT the 1:10 stock split to
CREATE a high price within a date range?
Or a 3:1 stock split prevent new highs from being achieved for a long
time to come?
Maybe the price is adjusted for the .26 dividend but the math seems a bit
> off.
>
Adjusted high price for 3/30 = Unadjusted high * Adjusted close /
Unadjusted close = $32.75 * $32.429875 / $32.71 = $32.4695324442067
> Just looking for a little clarity.
>
>
Hope that helped.
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar