Python script to extract Investment Transactions to CSV - Initial release v1b
All, please find attached my Python script that will allow you to extract your Investment transactions to CSV file. There are lots of user options. Let me know if you have any issues. This script is read-only.
extract_investment_transactions_csv.py - v1b
Comments are currently closed for this discussion. You can start a new one.
Keyboard shortcuts
Generic
? | Show this help |
---|---|
ESC | Blurs the current field |
Comment Form
r | Focus the comment reply box |
---|---|
^ + ↩ | Submit the comment |
You can use Command ⌘
instead of Control ^
on Mac
Stuart Beesley (Mr Toolbox) closed this discussion on 10 Nov, 2020 06:00 PM.
Stuart Beesley (Mr Toolbox) re-opened this discussion on 11 Nov, 2020 05:40 PM
1 Posted by Stuart Beesley ... on 11 Nov, 2020 05:40 PM
Small update v1d
Stuart Beesley (Mr Toolbox) closed this discussion on 11 Nov, 2020 05:40 PM.
Stuart Beesley (Mr Toolbox) re-opened this discussion on 27 Nov, 2020 10:35 AM
2 Posted by Stuart Beesley ... on 27 Nov, 2020 10:35 AM
All, if you use my extract_investment_transacttions_csv script or others from me, please update them all to the latest version. ZIP of all attached.
Stuart Beesley (Mr Toolbox) closed this discussion on 27 Nov, 2020 10:35 AM.
Stuart Beesley (Mr Toolbox) re-opened this discussion on 14 Dec, 2020 05:26 PM
3 Posted by Stuart Beesley ... on 14 Dec, 2020 05:26 PM
Now decommissioned and absorbed into Toolbox extension:
https://infinitekind.tenderapp.com/discussions/moneydance-development/4016-toolbox-preview-release-of-python-extension-for-moneydance
Stuart Beesley (Mr Toolbox) closed this discussion on 14 Dec, 2020 05:26 PM.
sprimost re-opened this discussion on 20 Dec, 2020 06:38 PM
4 Posted by sprimost on 20 Dec, 2020 06:38 PM
From: sprimost --just a fellow user.
Hmm. This script does not seem to be working for me. See errorlog from
MoneyBot below.
Using MD 2019.3 on LINUX Manjaro. By default, using LibreOffice Calc.
Any ideas, or should I look into modifying the script (I have a "basic"
working knowledge of Python having done a script similar to this. Maybe
this script will give me an idea how to fix some of the issues on am
having with the output.
/sprimost
Beginning file
/home/sprimost/Finance/Installed/extract_investment_transactions_csv.py
at Sun Dec 20 13:32:20 EST 2020
StuWareSoftSystems...
extract_investment_transactions_csv.py: Python Script
Initialising.......Version:1d
User Parameters...
Hiding Hidden Securities...
Hiding Inactive Accounts...
Hiding Hidden Accounts...
Selecting ALL Currencies...
Selecting ALL Securities...
Selecting ALL Accounts...
Including Opening Balances...
Script will adjust for Stock Splits...
user date format....: %Y/%m/%d
Non-ASCII characters will not be stripped from file: Using Delimiter: ,
WARNING: file exists,but assuming user said OK to overwrite..
Will extract investment transactions to file:
/home/sprimost/Downloads/extract_investment_transactions.csv ...
Investment Transaction Records selected: 2101
Error running script: Traceback (most recent call last):
File
"/home/sprimost/Finance/Installed/extract_investment_transactions_csv.py",
line 1337, in <module>
ExportDataToFile()
File
"/home/sprimost/Finance/Installed/extract_investment_transactions_csv.py",
line 1274, in ExportDataToFile
writer = csv.writer(csvfile, dialect='excel',
quoting=csv.QUOTE_MINIMAL, delimiter=csvDelimiter)
File
"/home/sprimost/Finance/Installed/extract_investment_transactions_csv.py",
line 1274, in ExportDataToFile
writer = csv.writer(csvfile, dialect='excel',
quoting=csv.QUOTE_MINIMAL, delimiter=csvDelimiter)
TypeError: "delimiter" must be an 1-character string
Traceback (most recent call last):
File
"/home/sprimost/Finance/Installed/extract_investment_transactions_csv.py",
line 1337, in <module>
ExportDataToFile()
File
"/home/sprimost/Finance/Installed/extract_investment_transactions_csv.py",
line 1274, in ExportDataToFile
writer = csv.writer(csvfile, dialect='excel',
quoting=csv.QUOTE_MINIMAL, delimiter=csvDelimiter)
File
"/home/sprimost/Finance/Installed/extract_investment_transactions_csv.py",
line 1274, in ExportDataToFile
writer = csv.writer(csvfile, dialect='excel',
quoting=csv.QUOTE_MINIMAL, delimiter=csvDelimiter)
TypeError: "delimiter" must be an 1-character string
5 Posted by Stuart Beesley ... on 31 Dec, 2020 05:50 PM
This was fixed.
URL for downloads is now:
https://yogi1967.github.io/MoneydancePythonScripts/
Stuart Beesley (Mr Toolbox) closed this discussion on 31 Dec, 2020 05:50 PM.
Stuart Beesley (Mr Toolbox) re-opened this discussion on 15 Feb, 2021 10:57 PM
6 Posted by Stuart Beesley ... on 15 Feb, 2021 10:57 PM
FYI - All my extract scripts have now been consolidated into a single script/extension called extract_data. The old individual scripts have been decommissioned.
https://yogi1967.github.io/MoneydancePythonScripts/
Stuart Beesley (Mr Toolbox) closed this discussion on 15 Feb, 2021 10:57 PM.