Real-Time Stock Market Spreadsheet Creator

I am in need of someone proficient in Google Sheets and stock market calculations to create a responsive document for me. This document will handle numeric data exclusively and deal with real-time stock market info.

Responsibilities:
- Create a Google Spreadsheet tailored to my specifications
- Ensure the sheet updates every minute with live stock market data

Required Skills/Experience:
- Excellent command of Google Sheets including all its features and functionalities
- Proven experience with real-time data management
- Background in handling stock market data or similar financial data
- Good understanding and execution of basic mathematical calculations
- Accuracy and attention to detail
- Strong analytical skills and ability to work with complex data

The ideal candidate will have experience in working with live data, particularly with stock markets, and have proficient knowledge of Google Sheets including its handling of numerical data. Your task will mainly involve making the sheet update every minute.


I need your help with a project that involves monitoring real-time EMA crossovers for all stocks in the Indian stock market and updating a Google Sheet with this information.

Project Overview
The goal is to create a system that monitors a live 5-minute chart of each stock and detects crossovers of the 20, 50, and 100 Exponential Moving Averages (EMA). Whenever a crossover occurs, the system should update a Google Sheet with the following details:

Timestamp: The date and time when the crossover occurs.
Stock Ticker: The symbol of the stock that crossed over.