Google Sheet Live Option Chain & PCR

Job ID: 38529592

Budget: ₹600 – ₹1,500 INR

I'm looking for a skilled Google Sheets expert with experience in financial data analysis to set up a live option chain and PCR (Put-Call Ratio) data tracking in a Google Sheet.

Key Requirements:
- Utilize the Stock Exchange API to pull in live option chain data and PCR figures.
- Create a visual representation of the PCR data using a line chart.
- Ensure the Google Sheet updates every 5 minutes.

Ideal Skills:
- Proficiency in Google Sheets and its advanced functions.
- Experience with the Stock Exchange API.
- Strong data analysis and financial market understanding.
- Ability to create clear and informative data visualizations.