I am in search for an automated spreadsheet regarding publicly traded stocks that offers live updates on specific information from a specific website and inputted into the spreadsheet via Python. I would prefer it to work in Microsoft Excel.
The functionality I want is outlined below:
1. Enter a stock ticker symbol into a column 2. Specific data such as: 'price', 'volume', 'relative strength', 'average true range', 'RSI' etc is automatically pulled from a source website into the designated columns 3. This information will update live as the site updates the chosen information (every 10 seconds)
That is all I require.
I currently receive all my data from a data source website (screenshot supplied) and I have circled the information that I would want to pull through to my designated spreadsheet.
I have also attached my spreadsheet as a visual representation of what I require.
To be clear the main objectives are:
• I can enter any stock symbol into my spreadsheet and get the required information • All information is constantly updated live in sync with the data source website. • To move away from manual input and automate my information.