These functions are originally created while developing systems for our client and intended to use with MS excel only. These are non-API functions.
Example usage: Cell A1 = "AXISBANK" B1 = 500.55 C1 = 505.25 'This is my entry price, when Ltp crosses this price, I want to BUY D1 = 510.30 'This my example Target 505.25 * 1% E1 = 500.2 ' This my example stoploss 505.25 * -1% F1 = 125 'Qty to trade G1 = TIME(HOUR(NOW()),MINUTE(NOW()),SECOND(NOW())) > Time(9,30,0) 'I want to trade only after 0930am. G1 will be TRUE, the moment it crosses system time crosses 09:30:00 H1 = 1 'I want to trade only 1 buy, no trade after that, I will just take whatever the profit or loss I1 = GetBuySignal(A1,B1,C1,G1,H1,F1,.....)
The moment Ltp crosses entry price and time > 09:30, I1 will display "BUY". I'll act on this "BUY" to place order
I1 will display "BUY" only once, on next excel calculation it will return "BOUGHT", so the PlaceOrder formula in J1 will be called only once. Even if the price falls below entry price and crosses again, GetBuySignal will still return "BOUGHT" until, you have called GetShortSignal on some formula and GetShortSignal returned "SHORT"
GetShortSignal is just opposite of GetBuySignal. GetSellSignal and GetCoverSignal are same as above except that it takes additional parameters target & stoploss price, will return SELL & COVER respectively when LTP crosess target or stoploss price.
GetAverageRange will return the average range (Day High- Day Low) for the last 3 months. This data is available only for NIFTY 200 stocks and equity segment. This function depends on data from nseindia.com Ex: GetAvgRange("AXISBANK")
Also pls explain
getshortsignal
GetBuySignal
Getaverage range
We will reply on this sometimes later.
Our comments are waiting for approval...
@madhukar
These functions are originally created while developing systems for our client and intended to use with MS excel only. These are non-API functions.
Example usage:
Cell A1 = "AXISBANK"
B1 = 500.55
C1 = 505.25 'This is my entry price, when Ltp crosses this price, I want to BUY
D1 = 510.30 'This my example Target 505.25 * 1%
E1 = 500.2 ' This my example stoploss 505.25 * -1%
F1 = 125 'Qty to trade
G1 = TIME(HOUR(NOW()),MINUTE(NOW()),SECOND(NOW())) > Time(9,30,0)
'I want to trade only after 0930am. G1 will be TRUE, the moment it crosses system time crosses 09:30:00
H1 = 1 'I want to trade only 1 buy, no trade after that, I will just take whatever the profit or loss
I1 = GetBuySignal(A1,B1,C1,G1,H1,F1,.....)
The moment Ltp crosses entry price and time > 09:30,
I1 will display "BUY". I'll act on this "BUY" to place order
J1 = IF(I1 = "BUY", PlaceOrder(......), "WaitingForBuy")
I1 will display "BUY" only once, on next excel calculation it will return "BOUGHT", so the PlaceOrder formula in J1 will be called only once. Even if the price falls below entry price and crosses again, GetBuySignal will still return "BOUGHT" until, you have called GetShortSignal on some formula and GetShortSignal returned "SHORT"
More on this in next post..
Getaverage range
@HowUTrade
@sujith
GetShortSignal is just opposite of GetBuySignal.
GetSellSignal and GetCoverSignal are same as above except that it takes additional parameters target & stoploss price, will return SELL & COVER respectively when LTP crosess target or stoploss price.
GetAverageRange will return the average range (Day High- Day Low) for the last 3 months. This data is available only for NIFTY 200 stocks and equity segment. This function depends on data from nseindia.com
Ex: GetAvgRange("AXISBANK")