Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have some trade data that comes in from my broker that can contain multiple lines related to one trade. See example below.
Comments about the data.
For each trade I want the table to show the fields from row 1. When there is a multiline trade, then I want each line to have the date and time shown, so I get a nice clean table.
Notes Time Placed Spread Side Qty Pos Effect Symbol Exp Strike Type PRICE TIF Status |
3/19/2018 12:34 STOCK BUY 5 TO OPEN DIS STOCK 101.2599 101.26 LMT |
3/19/2018 12:29 STOCK BUY 2 TO OPEN AMZN STOCK 1530.15 1530.15 LMT |
3/19/2018 12:28 CUSTOM BUY 1 TO CLOSE AMZN 6-Apr-18 1572.5 PUT 60.5 -28.22 LMT |
SELL -2 TO CLOSE AMZN 6-Apr-18 1570 PUT 58.84 CREDIT |
SELL -1 TO OPEN AMZN 6-Apr-18 1532.5 PUT 37.76 |
BUY 2 TO OPEN AMZN 6-Apr-18 1522.5 PUT 33.36 |
3/26/2018 8:43 CUSTOM SELL -6 TO OPEN BA 6-Apr-18 332.5 PUT -4.43 LMT DAY FILLED |
BUY 12 TO OPEN BA 6-Apr-18 330 PUT <empty> |
BUY 6 TO CLOSE BA 29-Mar-18 325 PUT <empty> |
SELL -12 TO CLOSE BA 29-Mar-18 322.5 PUT <empty> |
3/26/2018 8:40 CUSTOM SELL -1 TO OPEN AMZN 6-Apr-18 1535 PUT -11.7 LMT DAY FILLED |
BUY 2 TO OPEN AMZN 6-Apr-18 1532.5 PUT <empty> |
BUY 1 TO CLOSE AMZN 6-Apr-18 1502.5 PUT <empty> |
SELL -2 TO CLOSE AMZN 6-Apr-18 1500 PUT <empty> |
Thank you for your time.
John
Solved! Go to Solution.
Thanks for the suggestion. The info was helpful to provide me with additional ideas and background.
While I was not able to develop a specific solution to this issue, I am able to solve the problem a different way. I went back and found a much cleaner data source that has one row per security, with each row containing the description in a separate field. This let me split the table for the description into the component parts, (underlying, expiration date, strike price, and call or put)
The only disadvantage is that this alternative data source is batch updated overnight, rather than in real time after the trade. However, for my purposes this is sufficient.
Thanks
John
Thanks for the suggestion. The info was helpful to provide me with additional ideas and background.
While I was not able to develop a specific solution to this issue, I am able to solve the problem a different way. I went back and found a much cleaner data source that has one row per security, with each row containing the description in a separate field. This let me split the table for the description into the component parts, (underlying, expiration date, strike price, and call or put)
The only disadvantage is that this alternative data source is batch updated overnight, rather than in real time after the trade. However, for my purposes this is sufficient.
Thanks
John
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |