Excel 365 VBA for TradingView Chart Data Extraction

Job ID: 38772484

Budget: $30 – $250 USD

I need an Excel 365 VBA script that fetches, extracts, or web-scrapes minute-by-minute chart data (Time, Open, High, Low, Close, Volume) from a TradingView.com chart. The data extraction needs to start at 4:00 PM on the previous trading day and continue up to 3:59 PM of the current trading day for each minute displayed on the chart. Pre-market, during open market, and after market.

The script needs to:
·        Log each minute's data in real time, maintaining a continuous and orderly sequence of entries.
·        Store the data in a structured format (e.g., a column or table).
·        Fetch data from a specified URL associated with my TradingView data subscription.
·        Ensure ultra-low latency for real-time data logging.

Please note that TradingView does not currently offer API for individual users. Also, please account for one adjustment or fine-tuning if any issues are encountered during the initial implementation. Log errors to a text file in a designated folder.

I've attached a sample Excel file to illustrate my expectations.

My budget is currently low but if you can ensure that it runs smoothly without any issues, I am willing to consider any bid for as long as it's within reason.

Thank you.