I am trying to build an automated trading system in sierra chart to use with the s&p 500.
I am required to write a function to define when i want the program to make a buy entry.
I dont have enough knowlege in excel :\ and i would be happy if you will help me write the function.
i want the function to do the following: 1. there must be at least 2 points distance between the price at 16:30 that day (gmt +2) to the entry price.
2. i want the program to make a buy when the market price touch a daily pivot points which are in cells - aj3, ak3, ah3, al3, ak3, ag3.
3. i want the program to make a buy only if the distance between the pivot point and one of the values in cells aq3 - bm3 will be 1.5 points or less
thank you in advance!!
my email is: email@example.com
You might have a things a bit around, from what i know about Sierra, you need to write advance strategy, as this is writtent in C++ there is nothing to prevent you from including MS libraries to read and manipulate any MS object, but i do not think you can do it from MS Excel (Happy to stand corrected...)
And it is a bit of a work to handle spreadsheets from C++....