Toolathlon

quantitative-financial-analysis

Create a Google Sheet 2025_Market_Data with a worksheet Jun-Jul_2025, put the unadjusted daily open, high, low, close and volume for Apple, Tesla, Nvidia and Meta on every trading day in June and July 2025 into it in the shape example.csv establishes, then write Google Sheet : {url} on the Notion page Quant Research and comment on it.

Open in Gym

Task Prompt

Please create a Google Sheet named '2025_Market_Data' with a worksheet titled 'Jun-Jul_2025', retrieve daily stock data for Apple, Tesla, Nvidia, and Meta for each trading day in June and July 2025, automatically excluding non-trading days, and record all these data in the 'Jun-Jul_2025' worksheet following the existing examples in example.csv. I want the original prices rather than adjusted prices that account for stock splits and dividends. Once you have finished recording the data for each trading day in the worksheet, write the line 'Google Sheet : {url}' on the 'Quant Research' Notion page, and add a comment at the top of that page stating exactly this: "Monthly market data is ready. The reporting team can view it directly"