Forum Discussion
Create and populate a custom worksheet with imported data
I am working on a spreadsheet to record my options trading activity. I have created a basic worksheet with some formulas and conditional formatting to calculate and display the desired data from each...
I highly recommend you look into using https://support.microsoft.com/en-us/office/about-power-query-in-excel-7104fbee-9e62-4cb9-a02e-5bfb1a6c536a to import the data, and also highly recommend you NOT put each day into a separate tab!! Data analyses will be cumbersome, at best, in that format.
Your table should include a column with the date of the trading day, but all the data should be in the same table. With that base, you can use pivot tables and other built-in tools in Excel to present the data and analyses in just about any way, instead of being constrained to one-day-per-worksheet nightmares!