Intraday Pivot point trading xls

Hi All,

I have devolved intraday trading sheet based on Pivot point trading, it can also give buy and sell signals. It will fetch the data from the yahoo. If you want to get the real time data you need to login to yahoo. New Ideas are most welcome to improve this more.

The file size is more than 1MB, so uploaded in the share site.

http://www.4shared.com/document/bzEP_D9B/Intraday_13.html



Thanks,
RK

Dear deekonda,

thanx for the intraday RT sheet.What are the conditions columns(1 to 5) for buy

and sell?

thanks for sharing gud sw
can u explain the colum 1 to5 for buy n sell
how it work


jitin

good work, it will be very helpful to the day trader as supporting tool.

1) how to add the symbol
2) how to get nifty & bank nifty levels

rgds,
Thank u.

Hi,

You can add your scripts in Colums B. The script name should be matched withe NSE symbol list. For your reference you can check the simbol name in Prev.Day sheet.

The logic for buy and sell is simple. If the LTP is less than the pivot value it will give a sell Signal and the price is just below the pivot level for shorting. Reverse case if the LTP is above the Pivot value.

You can check the formula also there.

Please need more suggestions from your side to improve this more for making this more perfect.

Thanks,
RK

i tried to add the script in colum b as u say
it show the name in b cloum but no pivot or other data or even buy n sell signals

There was a problem with the Lookup values. I have modified the sheet and uploaded in share site.

I have modified this to fetch 50 stocks and you can change the script names in B column.

http:// w w w . 4 s h a r e d . c o m /file/230027332/54ee681a/Intraday.html

(Please remove the spaces)

-- RK

Hi Deekonda,
Thanx for your excellent development of excell sheet wirh spending lot of time. To start trading on opening of exchange, it is ok. The rt data received from yahoo is approx. 15 mnts delay and as a result of which the buy and sell triggers are reflecting and the entry/exit might be wrong. Pl. correct me, if I am wrong? Another point, It will be more convient, if you can add link on the previous day sheet to download the histo.data.Otherwise, it is ok only for pivot calculation.
Thanks.

thanks for fast reply
i got the new xl file i tried now i can add/remove the scrip n get data for the same . any other utility devlop by u