member badge
Jack
When syncing Hyperliquid using my public key, my perpetual trades (Futures) are not imported
Workaround
I need to download my "trade_history" CSV from Hyperliquid and modify it to a koinly-readable format
Ref. How to modify CSV files to import them to Koinly
  • Add
    Amount
    column and calculate it as closedPnl+fee (because pnl includes fee while I want to take it out)
  • Rename
    fee
    to
    Fee Amount
  • Add column
    Currency
    and fill it with
    USDC
  • Add column
    Fee Currency
    and fill it with
    USDC
  • Add column
    Tag
    and fill it with
    realized gain
  • Rename column
    time
    to
    Koinly Date
  • I may need to modify the time format to match koinly's required format YYYY-MM-DD hh:mm:ss
  • The file may be in a different timezone - How to import a CSV file using a different timezone