Forum Discussion

stockturner's avatar
stockturner
Regular Visitor
8 years ago
Solved

Multiline text import using query editor - variable number of rows.

  Hi, I have some trade data that comes in from my broker that can contain multiple lines related to one trade.   See example below.   The data is for actual trades in a brokerage account.  The...
  • stockturner's avatar
    stockturner
    8 years ago

    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