Option Trading in excel

Job ID: 33105189

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 .
Related categories: Data Processing Excel Statistics