Stcok Market dashboard

We are a proprietary trading firm who trades the equity markets in futures and options. We require an EXCEL specialist who also understands the equity market trading business.....from both an options as well as futures basis. An added advantage would be knowledge of Indian stock markets. We are primarily a writer of options. We require the specialist to prepare an Excel Dashboard which would have the following inputs from a report. Open trades, price entered, qty, etc. This would be for several different trading accounts. We will need to prepare the excel wherein previous day open positions (and closed) are entered into excel. Based on previous days closing price (which will need to be hyperlinked to a quote from the web/exchange), we need to be able to ascertain profit /loss. Further analysis and measurements of risk, movements, and real time update of prices, alerts.