Web Data Collection:
Data Extraction: We'll develop a web scraping solution using Python, specifically leveraging libraries like BeautifulSoup and Requests. This script will extract live data from your specified web source. It will be flexible to accommodate changes in time intervals.
Interval Selection: As you've mentioned, the script will have a dropdown box to select the desired time interval. The script will adapt accordingly, collecting data for the chosen interval.
Token Mapping: Your Excel sheet will contain token names. We'll create a mapping function to identify and match tokens, ensuring that only relevant data is extracted for each token.
Continuous Updates: The script can run on a predefined schedule (e.g., every minute) to ensure that you always have the latest data.