Tool for detecting and transforming exports from Schwab brokerage.
Available as a component of both a finport command line executable and as an open source Swift library to be incorporated in other apps.
FINporterChuck is part of the OpenAlloc family of open source Swift software tools.
Used by investing apps like Flow Allocator and Flow Worth.
The developers of this project (presently OpenAlloc LLC) are not financial advisers and do not offer tax or investing advice.
Where explicit support is provided for the transformation of data format associated with a service (brokerage, etc.), it is not a recommendation or endorsement of that service.
Software will have defects. Input data can have errors or become outdated. Carefully examine the output from FINporter for accuracy to ensure it is consistent with your investment goals.
For additional disclaiming, read the LICENSE, which is Apache 2.0.
There are actually two importers to handle Schwab positions. One for 'All' accounts, and a second for 'Individual' accounts. The files are named differently:
- All-Accounts-Positions-YYYY-MM-DD-000000.CSV
- Individual-Positions-YYYY-MM-DD-000000.CSV
Using the finport command line tool to transform either export requires four separate commands, as there are four outputs: accounts, account holdings, securities, and 'source meta':
$ finport transform SOMETHING-Positions-2021-06-30-012345.CSV --output-schema openalloc/account
$ finport transform SOMETHING-Positions-2021-06-30-012345.CSV --output-schema openalloc/holding
$ finport transform SOMETHING-Positions-2021-06-30-012345.CSV --output-schema openalloc/security
$ finport transform SOMETHING-Positions-2021-06-30-012345.CSV --output-schema openalloc/meta/sourceEach command above will produce comma-separated value data in the following schemas, respectively.
NOTE: "Cash & Cash Investments" holdings will be assigned a SecurityID of "CORE".
The 'source meta' can extract the export date from the content, if present, as well as other details.
Output schemas:
To transform the "XXXX1234_Transactions_YYYYMMDD-HHMMSS.CSV" export, which contains a record of recent sales, purchases, and other transactions:
$ finport transform XXXX1234_Transactions_YYYYMMDD-HHMMSS.CSVThe command above will produce comma-separated value data in the following schema.
Output schema: openalloc/transaction
NOTE 1: Schwab's transaction export does not contain realized gains and losses of sales, and so they are not in the imported transaction.
NOTE 2: Security transfers may only specify shares transferred, with no cash valuation specified.
To transform the "XXXX1234_GainLoss_Realized_YYYYMMDD-HHMMSS.CSV" export, available in the 'Closed Positions' view of taxable accounts:
$ finport transform XXXX1234_GainLoss_Realized_YYYYMMDD-HHMMSS.CSVThe command above will produce comma-separated value data in the following schema.
Output schema:
This app is a member of the Open Portfolio Project.
- Open Portfolio - Open Portfolio product website
- Open Portfolio Project - Github site for the development project, including full source code
Copyright 2021, 2022 OpenAlloc LLC
Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.
Contributions are welcome. You are encouraged to submit pull requests to fix bugs, improve documentation, or offer new features.
The pull request need not be a production-ready feature or fix. It can be a draft of proposed changes, or simply a test to show that expected behavior is buggy. Discussion on the pull request can proceed from there.
Contributions should ultimately have adequate test coverage and command-line support. See tests for current importers to see what coverage is expected.