Skip to content

Which broker import should we support next?

Feedback and ideasStarted by @holdmybeta0 replies

StaffPosted #1

You know the part where you download the file from your broker, and then sit there matching columns one by one, every month? That's the bit we want to take off you.

We're trying to cover as many brokers and banks as we can, and the list in the app keeps growing. The honest limit isn't effort, and it isn't difficulty either: for a lot of them we simply don't have the export format. Every broker writes its file differently, and there's no way to know how yours writes it without somebody who actually uses it showing us one.

That somebody can be you, and it takes about ten minutes, once. After that, nobody with your broker matches a column again.

1. Tell us your broker

Name and country, one line. If someone already said yours, reply to them so we can see how many of you there are. The ones most people ask for come first.

2. Send a sample file

To hello@turbobulls.com, no need to wait for us to ask. What makes a file useful:

  • Your export as it comes out, with your data swapped out rather than deleted. Every column stays, header row exactly as your broker wrote it.
  • Fake values in their place: RO00XXXX0000000000000000 for an account number, an invented name, round made-up amounts.
  • Number and date formatting left alone. If it says 1.234,56, keep it that way. Same for currency codes and the exact wording of the transaction types.
  • Bank statement? The description column kept, and the header and totals rows, with invented shop names. That's what an import has to recognise and skip.
  • Five to ten rows, covering the kinds of entries you have: buy, sell, dividend, fee, deposit, withdrawal, currency exchange, a split, a correction. The awkward ones help most.

Editing it without breaking it

Caution

Double-clicking a CSV into Excel and saving it again quietly rewrites it: your dates come back in a different shape and 1.234,56 turns into 1234.56, which is exactly what we need to see. Two ways round it:

  • Google Sheets: File, Import, Upload, and set "Convert text to numbers, dates, and formulas" to No. Edit, then File, Download, Comma-separated values.
  • A plain text editor: Notepad or Notepad++ on Windows, TextEdit in plain text mode on Mac, Sublime, , VS Code on either.

If your export is an XLSX, any spreadsheet is fine. Change the values, save it as xlsx.

Warning

Don't paste anything from the file here, not even the column names. This community is public. Files go to hello@turbobulls.com, where they stay private, get used to build the import, and are deleted afterwards.

We won't throw dates around, these get built one at a time. What you will get is a post here the day yours works, and the Broker scout badge on your handle 🏅 with it in the release note (if you don't tell us otherwise)

1 found this helpful

No replies yet. Be the first to answer.

Sign in to reply with your Turbobulls account.