Option Trading in excel
Budget: ₹12,500 – ₹37,500 INR
I am looking for someone to build me a custom excel file that brings all relevant option trading data into one clear screen .
1. The excel should be able to fetch the option chain data for nifty and bank nifty on a 1/2/3 minute basis from the NSE website . Or any other day source
2. Perform analysis on it to calculate active strikes , strike OI based pcr , option Greeks and resistance / support levels
3. Should be able to get future prices as well
3. Should be able to calculate and display moving averages and upto 6 oscillator graphs for nifty and bank nifty
4. Display a straddle index, a Calendar call tool
Depending on the success of this project I may want another project executed to develop trading algos . I am looking for some one who understand excel and derivative instruments like future and options as well as coding excel and algos .
1. The excel should be able to fetch the option chain data for nifty and bank nifty on a 1/2/3 minute basis from the NSE website . Or any other day source
2. Perform analysis on it to calculate active strikes , strike OI based pcr , option Greeks and resistance / support levels
3. Should be able to get future prices as well
3. Should be able to calculate and display moving averages and upto 6 oscillator graphs for nifty and bank nifty
4. Display a straddle index, a Calendar call tool
Depending on the success of this project I may want another project executed to develop trading algos . I am looking for some one who understand excel and derivative instruments like future and options as well as coding excel and algos .