--- title: "Stonqs guides: broker imports, figures and first launch" description: "Step-by-step guides: which file your broker exports and what Stonqs makes of it, what to do when a row will not import, and how far the assistant goes." url: "https://stonqs.app/guides/" lang: "en" updated: "2026-10-25" --- # One page per job Which file your broker gives you and which columns matter, what to do when a row refuses to go in, and what the assistant can answer once you switch it on. [Start with the first guide ](https://stonqs.app/guides/install-stonqs-first-portfolio/) ## Getting started 1. [ Install Stonqs and set up your first portfolioIn about five minutes you have an empty portfolio in a file on your own disk, a cash account, optionally a securities account, and a decision about price sources. There is no sign-up. Until you turn a price source on, the app fetches no prices or exchange rates. 5 min read](https://stonqs.app/guides/install-stonqs-first-portfolio/) 2. [ Choose where prices and exchange rates come fromA new Stonqs profile fetches no prices and no exchange rates until you turn sources on, keyless ones included. You need one source of prices and one of exchange rates. This takes about five minutes, and ends with holdings in other currencies valued instead of blank. 5 min read](https://stonqs.app/guides/choose-price-and-exchange-rate-sources/) ## Getting your data in 1. [ Import a broker's CSV exportYou will load one broker export into a portfolio in four steps: choose the file, check the column mapping, link the instruments, write. Nothing is saved before the last button, and importing the same file twice adds nothing. 7 min read](https://stonqs.app/guides/import-broker-csv/) 2. [ Import an Interactive Brokers Flex QueryDefine a Flex Query with Trades, Cash Transactions and Corporate Actions, turn currency rates on, and download it as XML. Stonqs recognises the file, asks only which account it belongs to, and previews everything before writing. Options, futures, corporate actions and cancelled trades are not imported; the last step counts them. 5 min read](https://stonqs.app/guides/import-interactive-brokers-flex-query/) 3. [ Fill the gaps after an importA broker's export holds only that broker's half of the story. Four gaps follow: no deposits, a transfer read as a withdrawal, shares carried in at zero cost, a sale with no purchase. Each has a symptom on screen and a fix in the app. 8 min read](https://stonqs.app/guides/fill-gaps-after-import/) ## Reading the figures 1. [ Read your returnsPerformance shows two returns because they ask different questions. TWR is what the investments did, and the one Stonqs sets against an index. XIRR is what your money earned given when you paid it in, and it is always a yearly rate. Seven minutes, then you can follow the TWR in the calculation sheet and rerun the XIRR yourself. 7 min read](https://stonqs.app/guides/read-your-returns-twr-xirr/) 2. [ Track dividends and the tax withheldIncome shows three numbers for the same dividends: Accrued (before withholding), Tax withheld, and Received in the period (what reached your cash), across every account in view. Tax withheld fills only when the tax sits on the dividend's own row. Allow about six minutes. 6 min read](https://stonqs.app/guides/track-dividends-withholding-tax/) 3. [ Export a tax year's gains, dividends and costsIn Reports, pick a period that covers your year, then use Export CSV on the Realized, Dividends and Costs tabs. Each table becomes a file in your base currency, about eight minutes in all. Stonqs adds up what you imported and computes no tax: give the files to your tax adviser beside your broker's statements. 8 min read](https://stonqs.app/guides/realised-gains-dividends-tax-year-csv/) 4. [ Read your portfolio's riskThe Risk screen answers two questions about one window of your past: how much the portfolio moved from day to day (volatility), and how deep its worst fall from a peak was (maximum drawdown). It takes five minutes to read, and it describes what happened, not what will. 6 min read](https://stonqs.app/guides/read-portfolio-risk-volatility-drawdown-sharpe/) ## Compared with the alternatives 1. [ Compare your portfolio with an index fund or ETFChoose an ETF or fund as the Benchmark instrument on the Performance screen and Stonqs shows its return over your period, and your excess over it in percentage points. About ten minutes. The benchmark counts price only, so a fund that pays out dividends is understated. 10 min read](https://stonqs.app/guides/compare-portfolio-with-index-etf/) --- [ Stonqs](https://stonqs.app/) A portfolio tracker that runs on your own computer. Free, open source, no account. ## Product [Download](https://stonqs.app/download/) [Privacy](https://stonqs.app/privacy/) ## Learn [Guides](https://stonqs.app/guides/) [Blog](https://stonqs.app/blog/) [FAQ](https://stonqs.app/faq/) ## Project [About](https://stonqs.app/about/) [Source code](https://github.com/vvvlladimir/stonqs) [Changelog](https://github.com/vvvlladimir/stonqs/blob/main/CHANGELOG.md) [Discussions](https://github.com/vvvlladimir/stonqs/discussions) [Report a bug](https://github.com/vvvlladimir/stonqs/issues) Stonqs is a tool for recording and analysing your own investments. It is not financial, tax or legal advice, and neither are the answers of its assistant. Market data comes from free third-party sources with no guarantee of accuracy. This site sets no cookies and loads nothing from other servers; the only thing it keeps in your browser is the language you pick. [Legal notice](https://stonqs.app/legal-notice/) [Privacy policy](https://stonqs.app/privacy-policy/)