Skip to content

Instantly share code, notes, and snippets.

@matsimon
Last active February 3, 2026 16:04
Show Gist options
  • Select an option

  • Save matsimon/093d0d1c9fac5b441bf83afb19fc3e2e to your computer and use it in GitHub Desktop.

Select an option

Save matsimon/093d0d1c9fac5b441bf83afb19fc3e2e to your computer and use it in GitHub Desktop.
Portfolio Performance: Work in progress CSV mapper for True Wealth
{
"delimiter": ",",
"columns": [{
"field": "date",
"format": "yyyy-MM-dd",
"label": "date"
}, {
"field": "type",
"format": "DEPOSIT=;REMOVAL=;INTEREST=Intr;INTEREST_CHARGE=;DIVIDENDS=Dividend;FEES=;FEES_REFUND=;TAXES=;TAX_REFUND=;BUY=Buy;SELL=Sell;TRANSFER_IN=;TRANSFER_OUT=",
"label": "type"
}, {
"field": "currency",
"label": "currency"
}, {
"field": "taxes",
"format": "0,000.00",
"label": "price"
}, {
"field": "shares",
"format": "0,000.00",
"label": "shares"
}, {
"field": "value",
"format": "0,000.00",
"label": "amount"
}, {
"field": "taxes",
"format": "0,000.00",
"label": "taxes"
}, {
"field": "fees",
"format": "0,000.00",
"label": "fees"
}, {
"field": "isin",
"label": "isin"
}, {
"label": "value"
}, {
"label": "value currency"
}, {
"field": "name",
"label": "security name"
}
],
"isFirstLineHeader": true,
"skipLines": 0,
"label": "TrueWealth 1.2",
"encoding": "UTF-8",
"target": "account-transaction"
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment