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 set of trade transactions (option exchange files report trade activity over various intervals.) At this point, I am manually importing the data from the exchange platform in their default format of CSV, then converting to conventional Excel worksheet format to use in my custom worksheet, and then clumsily copying/applying the formulas and conditional formatting manually to the new data set.
My objective is to create an Excel workbook that will import the data from the CSV file, automatically populate the associated fields in the dedicated worksheet correctly, and apply the formulas and conditional formatting to produce the desired output. I anticipate the workbook will consist of worksheet tabs for each trading day’s activity (i.e., Monday through Friday).
Any tips, hints or suggestions are very much appreciated. Finally, is there a means to attach sample files in these threads? Thank you!
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 set of trade transactions (option exchange files report trade activity over various intervals.) At this point, I am manually importing the data from the exchange platform in their default format of CSV, then converting to conventional Excel worksheet format to use in my custom worksheet, and then clumsily copying/applying the formulas and conditional formatting manually to the new data set. My objective is to create an Excel workbook that will import the data from the CSV file, automatically populate the associated fields in the dedicated worksheet correctly, and apply the formulas and conditional formatting to produce the desired output. I anticipate the workbook will consist of worksheet tabs for each trading day’s activity (i.e., Monday through Friday). Any tips, hints or suggestions are very much appreciated. Finally, is there a means to attach sample files in these threads? Thank you! Read More
