DaysGain CSV Import Guide

DaysGain supports CSV import so you can bring investment and cash activity records into the app.

CSV import is designed for users who want to migrate existing transaction history, restore data from a backup, or manage records in a spreadsheet.

The Easiest Way to Start

The safest way to create a correctly formatted CSV file is to export your data from DaysGain first, then use the exported file as your template.

Recommended workflow:

1. Go to Settings → Export CSV in DaysGain.
2. Open the exported file in a spreadsheet app.
3. Add, edit, or append rows using the same column format.
4. Save the file as CSV.
5. Import the updated CSV back into DaysGain.

If you are starting fresh with no existing data, follow the format described below.

CSV Format

DaysGain uses one CSV format for both import and export.

Your CSV file must include a header row. Column order does not matter. Column names are case-insensitive.

The standard DaysGain CSV header is:

date,activity_category,type,account_name,owner_name,account_type,institution,currency,ticker,security_name,market,quantity,price,cash_amount,fee,notes

What You Can Import

DaysGain CSV import supports:

• Buy transactions
• Sell transactions
• Deposits
• Withdrawals

Dividend and split events are not imported manually through CSV. DaysGain retrieves dividend and split data from market data providers when available.

Required Columns

Every CSV file must include these columns:

Optional Columns

Activity Rules

Buy and Sell Rows

For buy and sell rows:

• activity_category must be transaction.
• type must be buy or sell.
• ticker, quantity, and price should be filled.
• cash_amount should be blank.
• fee can be filled if there is a commission or transaction fee.

Example:

date,activity_category,type,account_name,owner_name,account_type,institution,currency,ticker,security_name,market,quantity,price,cash_amount,fee,notes
2026-01-15,transaction,buy,Donald-TFSA-TD,Donald,TFSA,TD,USD,AAPL,Apple Inc.,USA,5,210.50,,9.99,

Deposit and Withdraw Rows

For deposit and withdraw rows:

• activity_category must be transfer.
• type must be deposit or withdraw.
• currency must be filled.
• cash_amount must be filled.
• ticker, security_name, market, quantity, price, and fee should usually be blank.

Example:

date,activity_category,type,account_name,owner_name,account_type,institution,currency,ticker,security_name,market,quantity,price,cash_amount,fee,notes
2026-01-05,transfer,deposit,Donald-TFSA-TD,Donald,TFSA,TD,CAD,,,,,,5000.00,,Initial deposit
2026-04-01,transfer,withdraw,Donald-TFSA-TD,Donald,TFSA,TD,CAD,,,,,,1000.00,,

Supported Activity Combinations

Ticker and Market Detection

Use the full market symbol for the ticker field, including any exchange suffix.

DaysGain determines the market using this priority:

1. market, if provided.
2. Inferred from the ticker suffix if market is blank.
3. currency, if both market and ticker suffix are ambiguous.

Ticker availability and market data quality may vary by provider.

Example CSV

date,activity_category,type,account_name,owner_name,account_type,institution,currency,ticker,security_name,market,quantity,price,cash_amount,fee,notes
2026-01-05,transfer,deposit,Donald-TFSA-TD,Donald,TFSA,TD,CAD,,,,,,5000.00,,Initial deposit
2026-01-15,transaction,buy,Donald-TFSA-TD,Donald,TFSA,TD,USD,AAPL,Apple Inc.,USA,5,210.50,,9.99,
2026-01-20,transaction,buy,Donald-RRSP-TD,Donald,RRSP,TD,CAD,RY.TO,Royal Bank of Canada,CAN,10,132.80,,0,
2026-02-10,transaction,buy,Donald-Taxable-IBKR,Donald,Taxable,IBKR,HKD,0700.HK,Tencent Holdings,HKG,100,380.00,,0,
2026-02-20,transaction,buy,Donald-Taxable-IBKR,Donald,Taxable,IBKR,CNY,601398.SS,ICBC,CHN,1000,6.52,,0,
2026-03-15,transaction,sell,Donald-TFSA-TD,Donald,TFSA,TD,USD,AAPL,Apple Inc.,USA,2,245.00,,9.99,Partial sell
2026-04-01,transfer,withdraw,Donald-TFSA-TD,Donald,TFSA,TD,CAD,,,,,,1000.00,,

Starting Without Complete History

You do not need every historical trade to start using DaysGain.

If you already hold a position but do not have the full transaction history, add one initial buy row using your current share count and average cost.

Example:

date,activity_category,type,account_name,owner_name,account_type,institution,currency,ticker,security_name,market,quantity,price,cash_amount,fee,notes
2026-04-28,transaction,buy,Donald-RRSP-TD,Donald,RRSP,TD,USD,MSFT,Microsoft Corp.,USA,50,320.00,,0,Initial holding based on average cost

DaysGain will track your position from this date forward. Gain/loss before this date will not reflect your actual history.

If you do not know your exact average cost, you can use an estimate or current market price. Gain/loss figures will be based on whichever cost you enter.

Import Tips

• Use one row per activity.
• Keep account_name, owner_name, account_type, and institution consistent for the same account across all rows.
• Use YYYY-MM-DD date format when possible. Other formats such as MM/DD/YYYY may also be accepted.
• Use positive numbers for both buy and sell quantities.
• Use positive numbers for both deposit and withdraw cash amounts.
• Export a backup from DaysGain before importing large changes.
• Review your portfolio after importing to confirm holdings and values look correct.

Data Accuracy

DaysGain relies on the data you enter or import.

Incomplete, duplicated, incorrectly formatted, or inconsistent CSV data may cause inaccurate portfolio values, cost basis, gain/loss figures, dividend summaries, account summaries, or charts.

Market data, dividends, exchange rates, and corporate actions are sourced from third-party providers and may be delayed, incomplete, inaccurate, or unavailable.

You should verify important financial figures with your brokerage, financial institution, tax advisor, or other qualified professional.

Privacy and Security

CSV files may contain investment records and financial information.

Store, back up, and share exported CSV files carefully.

DaysGain is designed as a local-first app. Your portfolio records are stored on your device unless you choose to export, share, or otherwise provide them outside the app.

Need Help?

If you run into issues or have questions, contact us at:

hello@daysgain.com

When reporting an import issue, please include:

• App version
• iOS version
• Device model
• A description of what went wrong
• A sample of the rows that failed, with sensitive information removed

Please do not include sensitive personal or financial information unless you choose to do so.