-
Notifications
You must be signed in to change notification settings - Fork 1
How to plug in your own data
wilsonleong edited this page Feb 6, 2022
·
2 revisions
Coming Soon... Work In Progress...
The spreadsheet has multiple sheets:
- Cash: cash accounts in banks & brokers, physical cash, crypto accounts, physical gold, etc.
- Transactions: full list of transaction history (buy, sell, dividends)
- Security: security referential data
- Platform: broker investment accounts, cash, crypto, etc.
This sheet has the following columns:
- AccountName: name of the cash account (e.g. Cash AUD, Cash EUR, Cash GBP, Cash USD, etc.)
- Type: Bank (cash account in bank) / Cash (physical cash in safe)
- Currency (AUD, EUR, GBP, SGD, HKD, USD, XAU, etc. where cryptos are assumed to be denominated in USD and converted to USD equivalent)
- Balance
This sheet has the following columns:
- Platform: broker account
- Date: date in YYYY-MM-DD format
- Type: buy / sell / dividend
- CostInPlatformCcy: the original investment cost (buy), or the proceed amount (sell)
- PriceInSecurityCcy: the transaction price in security currency, e.g. US ETF in USD traded in Singapore account with platform ccy=SGD will be "USD"
- Quantity
- Dividend: dividends or bond coupons in platform ccy, e.g. US ETF in USD paid dividend in USD in Singapore account with platform ccy=SGD - the USD amount needs to be converted to SGD amount for the dividend entry
This sheet has the following columns:
- BBGCode: Bloomberg ticker code (unique ID for a security); crypto ticker codes are made up and not actual Bloomberg codes
- Name: security name
- Currency: security currency
- AssetClass: Equity, Fixed Income, Crypto, Cash, etc.
- AssetType: ETF, Mutual Fund, STock, Crypto, Cash, etc.
- Category: user-defined category such as Energy, Financials, etc. (instead of industry standard GICS or BICS that are associated with data cost)
- FundHouse
- YahooFinanceTicker: the security ticker recognised by Yahoo Finance (for market data collection via Yahoo Finance API); this is usually the same as RICS with the exception of cryptos. Mutual Funds are usually not supported by Yahoo Finance
- Comment: additional comment on the security
This sheet has the following columns:
- PlatformName: e.g. TD UK / FSM HK / Binance
- PlatformCurrency: e.g. GBP, HKD, USD