Transform Data From TradeStation to Excel|General Excel Questions & Answers|Excel Forum|My Online Training Hub

For this particular strategy, there are two futures contracts purchased each time (within the red boarder).
•Although each futures contract is purchased (buy in this case) on the same date, they are separate transactions (BLE1 & BLE2)
•The sell portion of the strategy are also separate, the strategy MAY exit (sell) each contract in 3 different ways.
•BLE1 contracts are sold as either BLX_1 or BLX_StopAll
•BLE2 contracts are sold as either BLX_Stop2 or BLX_StopAll

•The above is my intital guess at the format of the transformed data. It may need to change in order to facilitate easier analysis and dashboard display

•Once the data is transformed, there's a variety of analysis to perform and present in a dashboard: total equity (Column Z), total equity of just BLE1's, total equity of just BLE2's, Percent winning trades(total and separate), Monte Carlo analysis (total and separate), etc.

•Tradestation outputs the data to the left, quickly; essentially a push of a button.
•I'd like to get to the analysis portion in Excel just as quickly.
•I'm hoping your courses can help me accomplish that