My Math Forum  

Go Back   My Math Forum > Science Forums > Economics

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


Reply
 
LinkBack Thread Tools Display Modes
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
MJSlat is offline  
 
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?



Then the close relative to the low is:



Then you can take the tempclose as a percentage of the 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
Slinkey is offline  
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
Slinkey is offline  
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
MJSlat is offline  
December 30th, 2013, 09:11 PM   #5
Math Team
 
Joined: Oct 2011
From: Ottawa Ontario, Canada

Posts: 14,412
Thanks: 1024

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
Denis is offline  
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.
Slinkey is offline  
Reply

  My Math Forum > Science Forums > Economics

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



Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Got close, then got stuck. Shamieh Calculus 4 September 5th, 2013 10:16 AM
open and close set Taladhis Real Analysis 1 February 17th, 2013 05:39 AM
Find historical stock price daily and quarterly dividend per minh0279 Economics 1 September 14th, 2012 01:13 PM
Phi(Golden Ratio) and stock market price movements yurayurae Economics 2 August 8th, 2012 10:45 PM
marginal price and price-demand tsl182forever8 Calculus 2 March 15th, 2012 03:07 PM





Copyright © 2019 My Math Forum. All rights reserved.