Manual Data Fetch in Excel Barchart

Objective:
To manually fetch historical options data for the symbol 'QQQ' for every Monday from 06.01.2020 until 01.07.2024 using the Barchart add-on in Excel.
Open Excel and Navigate to Barchart:
Open Excel and click on the 'Barchart' tab at the top.
Select Historical Data Fetching:
Under the Barchart tab, click on 'Lists'.
Select 'Options' from the dropdown menu.
Set Up for Historical Data:
Choose 'Historical Data Fetching'.
Enter the symbol QQQ.
Select the Initial Date:
Select 01.07.24.
Approve the selection to fetch the data.
Repeat for All Mondays from 06.01.2020 to 01.07.2024:
Repeat steps 3 and 4 for each Monday (e.g., 06.01.2020, 13.01.2020, 20.01.2020, etc.) until 01.07.2024.
Storing the Data:
Store the data in the same sheet or open new sheets if needed.
Label each week's data with the corresponding date.


 ... Show more