Skip to main content

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


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

kktools-4.26.tar.gz (10.0 kB view details)

Uploaded Source

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

Hashes for kktools-4.26.tar.gz
Algorithm Hash digest
SHA256 7cc6849bf982e86cb4ef74f91afdd72ae23f6b2342854998af0f0980b97be447
MD5 0ba40f908b17d4aa075868356bf64bae
BLAKE2b-256 7ba40188464f77a492b46487016039d5cd2e24fe92748678c5bb4c304fb6d061

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page