A trading journal that fills itself every day

Once a day the scenario pulls the broker's trade report, lays the trades into columns and adds them to a table — the journal keeps itself without manual entry.

  • Trades pulled in automatically
  • Laid out into columns
  • Updated every day
  • Ready for analysis and stats
Ibkr
Set it up for yourselfScriptera

How it works

To create records from Microsoft SQL without manual input, use a ready-made scenario.

  1. Starts when: Daily Schedule Trigger
  2. Then: 1. Request Flex Report
  3. Then: 2. Extract Reference Code
  4. Then: Wait 10 Seconds
  5. Then: 3. Download Report
  6. Then: 4. Convert XML to JSON
  7. Then: 5. Split Trades
  8. Then: 6. Format Trade Fields
  9. Then: 7. Save to Google Sheet

You can launch this integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.

Similar scenarios