All in one pivot points in excel

Dear Traders,

I have created a pivot point trading system in excel, it includes all major pivot point techniques. Below is the link to download.

http://www.4shared.com/file/LkT6k_0T/All_In_One_Pivot_1.html

Need your inputs to improve more.

PS: Follow the Help sheet for more info.

thanks deekonda for pivot calculator, it is very useful

It's a good software. I would also recommend to insert column which can give indication of increase or decrease in volume compared to yesterday's or may be 10 days avg. volume.

This can make software even more helpful in taking buying & selling decision for intraday.

I tried for your requst, but Yahoo is not providing the data for previous volumes. If you have any idea please do let me know.

Thanks for trying on my suggestion.

I really do not have any idea from where we can get volume data clubed to the pivot data.

But may be you can re-work & get on-line signals from sites other than yahoo.

Thanks for your Idea...

YES... Every thing can be posible with Excel, will work on that and send you updated one.

Hi Deekonda,

I observe that your intraday worksheet has only selected stocks and their prices listed i.e. not all the ones on the Bhavcopy csv file are tracked for their latest prices.

If I need to add a stock to the intraday worksheet like say RALLIS INDIA, how do I do it ? Or would you have to change the excel sheet and resend it again ?

Please help !

Your excel sheet rocks !!

Thanks,
Naveen

Hello Naveen,

You can add NSE Code in Coloumn A in Intraday sheet. It will automatically take care abt the changes.

Reply me if you need any other info.
Have a nice trading!...

Hello Friends,

Thanks for your ideas in making this small tool to PERFECT!...

Now it will give calls based on the below logic.

1. If any script is crossed R1, then it will generate a call with BUY signal and update in Calls sheet. The target price will be only 1% for safe trade.
2. If any script is crossed S1, then it will generate a Short sell call and update in Calls sheet. The target price is also 1%.
3. Stop loss for any script is 0.5%

Many Many thanks to Traderji and Ravinder for giving this idea.

Here is the link.....

http://www.4shared.com/document/bU9sDttY/All_In_One_Pivot_22.html

Once again... I need your support and ideas to make this perfect....

Happy Trading!...