# 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.<br>
`get_last_ecb_rates()` - returns pandas dataframe with the latest valid ECB exchange rates for all published currencies.<br>
`df_to_excel("file_name.xlsx", dataframe)` - exports pandas dataframe to an excel file with pretty formatting.<br>
`dfs_to_excel("file_name.xlsx", list_of_dataframes)` - exports list of pandas dataframes to an excel file with pretty formatting.<br>
`Camt053` - class for parsing CAMT053 files (EOD bank statements, ISO20022 standard).<br>
`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`](https://github.com/khorevkp/KK_Tools/blob/master/LICENSE) file for full details.
Raw data
{
"_id": null,
"home_page": "https://github.com/khorevkp/KK_Tools",
"name": "kktools",
"maintainer": null,
"docs_url": null,
"requires_python": null,
"maintainer_email": null,
"keywords": null,
"author": "Konstantin Khorev",
"author_email": "khorevkp@gmail.com",
"download_url": "https://files.pythonhosted.org/packages/7b/a4/0188464f77a492b46487016039d5cd2e24fe92748678c5bb4c304fb6d061/kktools-4.26.tar.gz",
"platform": null,
"description": "# kktools\r\n\r\n\r\n========\r\n\r\nThis library provides python tools for finance and treasury specialists.\r\n\r\n## Installation\r\n\r\n`pip install kktools`\r\n\r\n## Realized Functionality\r\n`get_ecb_rates(\"CUR\", \"YYYY-MM-DD\")` - returns pandas dataframe with historical values for a given currency (\"CUR\") starting from the given date.<br>\r\n`get_last_ecb_rates()` - returns pandas dataframe with the latest valid ECB exchange rates for all published currencies.<br>\r\n`df_to_excel(\"file_name.xlsx\", dataframe)` - exports pandas dataframe to an excel file with pretty formatting.<br>\r\n`dfs_to_excel(\"file_name.xlsx\", list_of_dataframes)` - exports list of pandas dataframes to an excel file with pretty formatting.<br>\r\n`Camt053` - class for parsing CAMT053 files (EOD bank statements, ISO20022 standard).<br>\r\n`Pain001` - class for parsing PAIN001 files (payment initiation, ISO20022 standard).\r\n\r\n## Basic Usage\r\n\r\nImporting history of EUR/GBP exchange rates since 2000-01-01 and exporting it to an excel file with pretty formatting\r\n\r\n```\r\nimport kktools as kkt\r\n\r\ndf = kkt.get_ecb_rates(\"GBP\", \"2000-01-01\")\r\nkkt.df_to_excel(\"Historical_Rates.xlsx\", df)\r\n```\r\n\r\nParsing CAMT053 file and getting list of balances and list of all transactions:\r\n```\r\nfrom kktools import Camt053\r\n\r\ncamt = Camt053(file_name) # creates an object of Camt class you need to pass path+file_name of the CAMT053 file to be processed\r\ncamt.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.), \r\ncamt.transactions # returns list of all transactions in the file.\r\n\r\n```\r\n\r\n### License\r\nMIT licensed. Check the [`LICENSE`](https://github.com/khorevkp/KK_Tools/blob/master/LICENSE) file for full details.\r\n\r\n\r\n",
"bugtrack_url": null,
"license": null,
"summary": "Tools for finance and treasury specialists",
"version": "4.26",
"project_urls": {
"Homepage": "https://github.com/khorevkp/KK_Tools"
},
"split_keywords": [],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "7ba40188464f77a492b46487016039d5cd2e24fe92748678c5bb4c304fb6d061",
"md5": "0ba40f908b17d4aa075868356bf64bae",
"sha256": "7cc6849bf982e86cb4ef74f91afdd72ae23f6b2342854998af0f0980b97be447"
},
"downloads": -1,
"filename": "kktools-4.26.tar.gz",
"has_sig": false,
"md5_digest": "0ba40f908b17d4aa075868356bf64bae",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 9998,
"upload_time": "2024-10-20T16:54:17",
"upload_time_iso_8601": "2024-10-20T16:54:17.389484Z",
"url": "https://files.pythonhosted.org/packages/7b/a4/0188464f77a492b46487016039d5cd2e24fe92748678c5bb4c304fb6d061/kktools-4.26.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-10-20 16:54:17",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "khorevkp",
"github_project": "KK_Tools",
"travis_ci": false,
"coveralls": false,
"github_actions": false,
"lcname": "kktools"
}
JSON
