Help Defining a Trade Rule in Excel :O

[alfassy 10]

For weeks I am trying to define the last thing in my automated trading system.

I use sierra chart and my trading system is based on excel.

My strategy is based on market tension and is trying to predict market corrections.

There is a rule that if the price came 0.25 - 0.5 points from a pivot point, didn't touch the pivot and a market correction at the size of 2 points or more occurred I will not go into position using this specific pivot point. But if after the correction - the price got 5 points away from the pivot and 15 minutes have passed since the correction took place I can use the pivot again.

How can I define something like this? : \

can macros help me? How?

Thank you very much in advance

[MarkHocky 10]

Hi Alfassy,

 

Difficult to provide detailed advice without more details about how your spreadsheet is set up (e.g. frequency of price data), but the first thing that came to mind was:

 

You could calculate this as a separate 'indicator' in a new column in excel.

When the pivot point is set, start calculating your boundary (e.g. 0.5 points), and then switch on or off the indicator according to the other conditions you need to meet. This might look something like this (in psuedo code):

 

'=IF(AND(Pivot point = ON, Time stop = NO, Price > Pivot level), take position, no position)

 

You might need seperate columns to calculate your pivot boundary, and time stop switch....

 

Hope this helps!

 

Mark.

[alfassy 10]

Thank you in advance for your help

i have the date and ohlc of the price every 15 minutes in my sheet.

And i have 6 pivot point allready calculated on columns aa - af.

 

my biggest problem is defining the time sequence

meaning right now the price touches the pivot point, if before that the price made a market correction that started in up to 0.5 from the pivot point and lasted more than 2 points then i wont go into position, unless the market correction was more than 5 points from the pivot points and 15 minuted have passed since the market correction started.

 

i need to define a series of events in different times and i am not sure how to do that.

i am not sure how to defune things that happened in the "past"

[Tams 20]

if excel is proficient in doing the type of analysis that you want do...

then everybody would be doing it.

have you wonder why people would use ninjatrader (free) or multicharts or tradestation (free with account) to do this type of analysis and backtesting?

[alfassy 10]

so you are saying it would be easier defining these things using ninjatrader or other programs :]

thanks for the tip! i will try ninja!