Posted 13 Days Ago Job ID: 2090340 41 quotes received

Manual Data Fetch in Excel Barchart

Fixed Price or Hourly
Quotes (41)  ·  Premium Quotes (1)  ·  Invited (13)  ·  Hired (0)

  Send before: August 10, 2024

Send a Quote

Administrative & Secretarial Spreadsheets & Data Manipulation

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.

  1. Open Excel and Navigate to Barchart:

    • Open Excel and click on the 'Barchart' tab at the top.
  2. Select Historical Data Fetching:

    • Under the Barchart tab, click on 'Lists'.
    • Select 'Options' from the dropdown menu.
  3. Set Up for Historical Data:

    • Choose 'Historical Data Fetching'.
    • Enter the symbol QQQ.
  4. Select the Initial Date:

    • Select 01.07.24.
    • Approve the selection to fetch the data.
  5. 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.
  6. 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
Ran K Israel