member badge
Jack
When trying to import my
AssetChangeDetails_Copytrading
file, all transactions are skipped
Workaround
I need to edit the file and:
  • Lowercase the content of alls cells in the "Type" column (e.g. change
    Trade
    to
    trade
    ,
    Funding
    to
    funding
    , etc.)
  • Find and replace all
    pre-deduction refund
    with
    trade
  • Find and replace all
    pre-deduction
    with
    trade
How to lowercase a column quickly
  • Rename the column from
    Type
    to
    Type_
  • Create a new column called
    Type
  • Add a formula
    =LOWER(E3)
  • Fill this formula in the whole column