My Math Forum Stock Close Price Relationship to High or Low of the day

 Economics Economics Forum - Financial Mathematics, Econometrics, Operations Research, Mathematical Finance, Computational Finance

 December 29th, 2013, 11:42 AM #1 Newbie   Joined: Dec 2013 Posts: 2 Thanks: 0 Stock Close Price Relationship to High or Low of the day Hi and Thanks! I need to accurately gauge how close the closing price of the day was to the low of the day in one formula. How close the closing price is to the High of the day in a second formula. I am only looking for and counting those instances where the close is very close to one of these two extremes. I am currently utilizing the following formulas in Microsoft Excel for the Mac 2011. "=IF(CF3>=0.975*CD3,1,0)" Checks for High of the Day and scores either a (+1) if True or a (0) if False. "=IF(CF3<=0.975*CE3,1,0)" Checks for the Low of the Day and scores either a (+1) if True or a (0) if False. CF3 = Close of the Day - CD3 = High of the Day - CE3 = Low of the Day If I understand this correctly, the relationship between either the high or the low of the day must be within .025% to achieve a "True," response. My concern arose when I received a lot of false positives when the stock prices are in a small range or below \$1.00. Thanks for your suggestions and assistance, Michael
 December 29th, 2013, 04:06 PM #2 Member   Joined: Dec 2013 Posts: 82 Thanks: 0 Re: Stock Close Price Relationship to High or Low of the day Shouldn't you be taking into account the range for the day? $range=high-low$ Then the close relative to the low is: $tempclose=close-low$ Then you can take the tempclose as a percentage of the range: $percent=tempclose/range$ Now you can just ask, if percent is <= 0.025 then low was near to closing price, and if percent is >= 0.975 then high was near to closing price. I would rewrite your code like this: "=IF((CF3-CE3)/(CD3-CE3)<=0.025,1,0)" checks for low of the day "=IF((CF3-CE3)/(CD3-CE3)<=0.975,1,0)" check for high of the day. Hope that helps
 December 29th, 2013, 04:08 PM #3 Member   Joined: Dec 2013 Posts: 82 Thanks: 0 Re: Stock Close Price Relationship to High or Low of the day Noticed an error on the second line of code, "=IF((CF3-CE3)/(CD3-CE3)<=0.975,1,0)" check for high of the day should be "=IF((CF3-CE3)/(CD3-CE3)>=0.975,1,0)" check for high of the day
 December 30th, 2013, 07:12 PM #4 Newbie   Joined: Dec 2013 Posts: 2 Thanks: 0 Re: Stock Close Price Relationship to High or Low of the day Hi Slinkey and Happy New Year: I am sorry for the delay, Holidays kept me away from the computer. Thanks you for your assistance, knew that I was missing something. If you trade stocks send me an email at 3S@dc.com. I think I can return the favor. Michael
December 30th, 2013, 09:11 PM   #5
Math Team

Joined: Oct 2011

Posts: 14,597
Thanks: 1038

Re: Stock Close Price Relationship to High or Low of the day

Quote:
 Originally Posted by MJSlat If you trade stocks send me an email at 3S@dc.com. I think I can return the favor.
Ahem

January 2nd, 2014, 08:59 AM   #6
Member

Joined: Dec 2013

Posts: 82
Thanks: 0

Re: Stock Close Price Relationship to High or Low of the day

Quote:
 Originally Posted by MJSlat Hi Slinkey and Happy New Year: I am sorry for the delay, Holidays kept me away from the computer. Thanks you for your assistance, knew that I was missing something. If you trade stocks send me an email at 3S@dc.com. I think I can return the favor. Michael
You're welcome. I don't trade stocks but thanks anyway.

 Tags close, day, high, low, price, relationship, stock

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post Shamieh Calculus 4 September 5th, 2013 10:16 AM Taladhis Real Analysis 1 February 17th, 2013 05:39 AM minh0279 Economics 1 September 14th, 2012 01:13 PM yurayurae Economics 2 August 8th, 2012 10:45 PM tsl182forever8 Calculus 2 March 15th, 2012 03:07 PM

 Contact - Home - Forums - Cryptocurrency Forum - Top