How to transpose data from multiple lines to one line

[Robert Nicholson]

Imagine you have schedule d data that's formatted such that one line =
one transaction. ie. entry and exit cross lines. How do you then
transpose this data
so that you can match up entry and exits and record them on one line
like a schedule d form? I currently have a spreadsheet where each line
is a separate transaction but I'd like to make it so that the same
downloaded CSV data can be used whereby I can track PnL per trade
instead overall.

 

[Dennis Tucker]

Robert,

I will help if I can.

I do not believe that most people(including me) understand what a schedule d
form is.

If you can provide samples of what you have and can make a sample of the way
you want it to look like, that would be a great start.


Dennis