Excels for Help, in trading !!!

[Raj232]

My trades 24 Dec 2018
Excel sheet
Graph Adaniport
Graph Hindpetro

Hindpetro.. is still a hold (after buy) currently.. like to go up further (even if it corrects a bit today) in the coming 2-4 days (it is Rs 250.00 as of this writing) ... maybe upto 252.. 253 level or even 260 level in next few days ... .. lets see..

 

[ajeetsingh]

Thanks @ajeetsingh : Nice thread started.
Please clarify "As per client constraint" ... is it a limitation on the excel or client computer ?

I have prepared these files for traders in lieu of subscription
To safeguard their interest, I cant make free version absolute
hence deleted 2 columns....

 

[ajeetsingh]

Hindpetro.. is still a hold (after buy) currently.. like to go up further (even if it corrects a bit today) in the coming 2-4 days (it is Rs 250.00 as of this writing) ... maybe upto 252.. 253 level or even 260 level in next few days ... .. lets see..

I generally use 5 min chart or at max 15 min
which limit my view to intraday only so cant say where its heading as positional

 

[ajeetsingh]

Intraday Pivot Level Calculator

Its improvident to talk about supports and resistances without pivots.
Pivots are backbone of many traders for intraday trades
Many times stock respect these psychological levels
So here goes an excel which daily updates
and displays S/R levels of 200 stocks of category A
As per client constraint, I have deleted columns for S4 and R4
but I dont think that it will decrease value of sheet.
So download and enjoy !!!

 

[Raj232]

Is the excel file an exe file ?
mediafire.com/file/ni32e3jq98uy7p2/Pivot_Point_Calculator_Lite_m1.1.exe/file

Thanks for clarification in advance.

 

[ajeetsingh]

Is the excel file an exe file ?
mediafire.com/file/ni32e3jq98uy7p2/Pivot_Point_Calculator_Lite_m1.1.exe/file

Thanks for clarification in advance.

Ya, I already answered it.... I have converted excel to .exe just to safeguard formula used.
Its totally virus free and it wont install anything.
It runs an excel addin along with excel.... thats it

 

[Raj232]

Ya, I already answered it.... I have converted excel to .exe just to safeguard formula used.
Its totally virus free and it wont install anything.
It runs an excel addin along with excel.... thats it

Ok Thanks. Can you also please help posting a basic backtest for 1 - 2 indices (e.g. Nifty and Banknifty) signals.
e.g Nifty gave a BUY signal at 12:25 PM on 24-Dec-2018 and its sell signal came at xxx time on yyy date. That will give confidence to traders that the sheet is giving some good results ..

 

[prabhsingh]

Why are using excel for all this stuff and why not any programming language for same like Python or C#.Excel has its own limitations like drawing of charts through data set with indicators,MA's etc.With Python all such stuff can be done handled smartly.

 

[ajeetsingh]

Why are using excel for all this stuff and why not any programming language for same like Python or C#.Excel has its own limitations like drawing of charts through data set with indicators,MA's etc.With Python all such stuff can be done handled smartly.

Question is not what is easy or tough or having any limiting factor....
Question is, with which I am easy....
Since early days I worked with Excel
its handy with easy calculations and instant levels
For charting I totally relay on Amibroker 6.30
python is other world for me....
I am in my own space and dont want to leave that
Instead I am putting my efforts to learn new turnarounds of markets where I can grab small but instant profits.

 

[ajeetsingh]

Pivot Level Calculator (Advanced)

Around 341 people have enjoyed, Pivot Calculator (posted on 20 Dec)
So now I gave it more teeth and this new Beta version gives you edge over normal version
It plays decisive roll in taking Buy/Sell decision and comes handy
I have feeded data for more than 200 stocks
File is in form .exe as you all know, its done to safeguard my work.
It will run till 31 March 2020
You can post feedback in my thread:
https://www.traderji.com/community/threads/excels-for-help-in-trading.107356/

Download:
http://www.mediafire.com/file/38jz2j0r31mgfhk/Intraday_Pivot_Level_V2.0.exe/file