Automated TradingView to Excel Data Transfer
Budget: $750 – $1,500 USD
I need TradingView prices brought into Excel on continuous basis. Open, High, Low, Close, Volume to be recorded in Excel every minute on continuous basis, for pre-market, during open market, and after-market. This needs to be a dynamic coding where prices are brought down from TradingView and recorded automatically in Excel at the end of each minute, on continuous basis, for the ticker of my choosing. Time delay is very important, to be as instantaneous as possible. Off to the side I will have my model taking in those prices and calculating my metrics in real time as the prices are brought in minute after minute, and recorded vertically down. The code also needs to record the minute in the 9:30 AM/PM format. The price recording needs to start at 4:00 PM on the previous trading day, and conclude at 3:59 PM on the current trading day. The code either needs to be present in the excel file itself and linked to TradingView API, or if it is a standalone program, it needs to have the capability to be connected to multiple excel files. I need to be able to duplicate it for multiple number of tickers of my choosing. This is needed for day trading. I currently have Excel 2013, but I could get later version of Excel if need be. I do have a premium subscription with TradingView, but if other form of subscription is needed, I will change my subscription type.
The data transfer must occur in real-time to ensure the most up-to-date information is available. A standalone program could be in any programming language.
The solution should include basic security measures. Preferably, the solution should be implemented using VBA but if not possible, any standlone program would be fine, as specified above.
Detailed logs should be generated for error handling and notification purposes.
Error notifications should be displayed as on-screen alerts for immediate attention. The solution should include password protection for accessing the data. Error logs should be saved as a text file.
The data transfer must occur in real-time to ensure the most up-to-date information is available. A standalone program could be in any programming language.
The solution should include basic security measures. Preferably, the solution should be implemented using VBA but if not possible, any standlone program would be fine, as specified above.
Detailed logs should be generated for error handling and notification purposes.
Error notifications should be displayed as on-screen alerts for immediate attention. The solution should include password protection for accessing the data. Error logs should be saved as a text file.