Stonqs

Questions about Stonqs

Short, straight answers to what people ask before and after they install Stonqs: what it costs, where your data goes, how the import works and what the numbers mean.

Before you start

Is Stonqs really free? What's the catch?

There isn't one. Stonqs is open source under the AGPL: no paid tier, no ads, no account. There's also nothing to sell, because your data never leaves your computer. If paid extras ever appear, they'll be things that cost money to run, like sync between devices, and never a lock on what's free today.

Who is Stonqs for?

For people who invest on their own and have outgrown a spreadsheet: a few brokers, more than one currency, dividends from all over, and the nagging question of whether the portfolio is doing well or just growing because you keep paying in.

Who makes Stonqs, and what if the project stops?

Stonqs is an independent project from Germany, and its author tracks a real portfolio with it every day. If development ever stopped, the app you have would keep running, the code would stay public under the AGPL, and your portfolio would still be a standard SQLite file that any SQLite tool can open. You can export your transactions at any time.

Is it ready for my real portfolio?

It's an alpha, version 0.x. The calculations are covered by tests and the author uses it with real money, but expect rough edges and keep your broker statements. Before every database upgrade, Stonqs saves a copy of your data next to it.

Does Stonqs tell me what to buy?

No. Stonqs records and analyses what you already own. It makes no recommendations, and neither does its assistant. For anything that matters, especially your tax return, check the figures against your broker's statements.

Your data and privacy

Where is my data stored?

On your computer, in a database file inside your profile folder. There's no account and no server. Set a password on the profile and the file is encrypted.

Can anyone else see my portfolio?

No. There's no server that could hold it. To fetch prices, Stonqs sends the ticker it needs to the data source you chose, and that's all. Your holdings and amounts go nowhere, unless you switch on the AI assistant and let it read them.

How do I back up my portfolio?

Copy the database file in your profile folder, like any other file. That one file is the whole portfolio. A copy of an encrypted database stays encrypted.

Can I use it on two computers?

There's no automatic sync, because there's no server to sync through. To move a portfolio to another computer, copy the profile folder across.

What if I forget my password?

Then that profile's data is gone. There's no reset and no back door, which is the whole point of the encryption. The password is optional until you save a key for an AI provider, so only set one you'll keep.

Does it work without internet?

Yes. Every figure is calculated on your computer. You only need a connection to fetch new prices and exchange rates, and you can always enter prices by hand.

Getting your data in

My broker isn't on the list. Can I still import?

Yes. Stonqs reads any CSV. You tell it once which column is which, check every row before it's saved, and keep the mapping as a layout for next time. Interactive Brokers Flex statements are read directly.

Does Stonqs connect to my broker automatically?

No, and that's deliberate: Stonqs never asks for your broker login. You download an export from your broker and import it. Importing a file again adds only the rows that are new, so a monthly update stays quick.

Can it import PDF statements?

Not yet. Stonqs reads CSV and Interactive Brokers Flex XML. If your broker's export doesn't import cleanly, open an issue on GitHub with five anonymised rows and the header row.

Returns, dividends and taxes

Why does Stonqs show two returns?

Because they answer two different questions. Time-weighted return shows how your investments did, with deposits and withdrawals taken out; compare that one with an index. Money-weighted return shows how you did, with the timing of your money included.

Why is my return different from what my broker shows?

Usually because the broker counts something else. Many broker apps show the gain on what you hold today against what you paid for it, and fresh deposits move that figure. Stonqs separates the money you paid in from the money the market made, and covers all your accounts at once, sold positions included.

What can I track?

Shares, ETFs, funds and crypto, in cash and securities accounts in any currency. Anything without a public price, you can value by hand.

Does it track dividends and withholding tax?

Yes. Every dividend keeps the tax withheld at source as its own entry, so yields are based on the gross payment. You see income by year and by instrument, and the payments still to come.

Can Stonqs do my tax return?

No, but it gets the numbers ready. Reports list realised gains, dividends with the tax withheld, and the fees and taxes you paid, for any period, and export them to CSV for you or your tax adviser. What you owe depends on your country's rules, so Stonqs doesn't calculate it.

FIFO or average cost?

Both. FIFO is the default, and you can switch the portfolio to average cost. For a partly sold position, the positions table shows both methods side by side.

Can my accounts be in different currencies?

Yes. Each account keeps its own currency, each trade keeps the exchange rate of its day, and every total is shown in the base currency you pick. The part of a result that came from the exchange rate is shown separately.

What happens when a stock splits?

When a data source reports a split, Stonqs offers it to you instead of applying it by itself, because it can't know whether your broker already adjusted the position. Accept it, and the lots are adjusted with the same total cost.

Installing and updating

Which Mac download do I need?

Apple Silicon for any Mac from late 2020 on, Intel for older ones. About This Mac in the Apple menu tells you which one you have.

macOS says Stonqs is damaged. What now?

It isn't damaged. The alpha builds aren't signed with an Apple certificate yet, and that's how macOS words it. Move the app to Applications and run xattr -dr com.apple.quarantine /Applications/Stonqs.app in Terminal once. On Windows, the copy from the Microsoft Store opens without a warning; for the installer, click More info, then Run anyway.

How do updates work?

Once a day, Stonqs checks whether a new version is out and tells you what's in it. Nothing installs until you say so, and a version that fails its signature check is refused. A copy from the Microsoft Store is updated by the Store instead: the app tells you, and its button opens the Store page. You can switch the check off in the settings.

Discussions

Free for macOS, Windows and Linux.

Start with the demo portfolio, then import your own broker export.

macOS

Your system

Apple Silicon is any Mac from late 2020 on. Older Macs are Intel.

On a Mac, Stonqs needs one Terminal command after installing. Without it, macOS reports the app as damaged. How to do it, and why it's safe

All releases and checksumsBuild from source

Your download has started. One more step on macOS

  1. Open the downloaded .dmg and drag Stonqs into the Applications folder.
  2. Open Terminal: press ⌘ Space, type Terminal and press Return.
  3. Paste this command and press Return. If it worked, you'll see no output:
xattr -dr com.apple.quarantine /Applications/Stonqs.app

If it answers “No such file”, Stonqs isn't in Applications yet. Do step 1, then run the command again.