Tools for finance and treasury specialists
Project description
kktools
========
This library provides python tools for finance and treasury specialists.
Installation
pip install kktools
Realized Functionality
get_ecb_rates("CUR", "YYYY-MM-DD")
- returns pandas dataframe with historical values for a given currency ("CUR") starting from the given date.
get_last_ecb_rates()
- returns pandas dataframe with the latest valid ECB exchange rates for all published currencies.
df_to_excel("file_name.xlsx", dataframe)
- exports pandas dataframe to an excel file with pretty formatting.
dfs_to_excel("file_name.xlsx", list_of_dataframes)
- exports list of pandas dataframes to an excel file with pretty formatting.
Camt053
- class for parsing CAMT053 files (EOD bank statements, ISO20022 standard).
Pain001
- class for parsing PAIN001 files (payment initiation, ISO20022 standard).
Basic Usage
Importing history of EUR/GBP exchange rates since 2000-01-01 and exporting it to an excel file with pretty formatting
import kktools as kkt
df = kkt.get_ecb_rates("GBP", "2000-01-01")
kkt.df_to_excel("Historical_Rates.xlsx", df)
Parsing CAMT053 file and getting list of balances and list of all transactions:
from kktools import Camt053
camt = Camt053(file_name) # creates an object of Camt class you need to pass path+file_name of the CAMT053 file to be processed
camt.camt.statements_info # returns list of dictionaries for each statement with the following information: account id and owner name, all available balances (OPBD/CLBD/CLAV/PRCD/FWAV/etc.),
camt.transactions # returns list of all transactions in the file.
License
MIT licensed. Check the LICENSE
file for full details.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
File details
Details for the file kktools-4.26.tar.gz
.
File metadata
- Download URL: kktools-4.26.tar.gz
- Upload date:
- Size: 10.0 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/3.8.0 pkginfo/1.8.2 readme-renderer/34.0 requests/2.27.1 requests-toolbelt/0.9.1 urllib3/1.26.8 tqdm/4.63.0 importlib-metadata/4.11.2 keyring/23.5.0 rfc3986/2.0.0 colorama/0.4.4 CPython/3.9.7
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | 7cc6849bf982e86cb4ef74f91afdd72ae23f6b2342854998af0f0980b97be447 |
|
MD5 | 0ba40f908b17d4aa075868356bf64bae |
|
BLAKE2b-256 | 7ba40188464f77a492b46487016039d5cd2e24fe92748678c5bb4c304fb6d061 |