Sabtu, 04 Juni 2016

[smf_addin] Digest Number 3719

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.

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.

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.

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.

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.



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.​
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar