Skip to content
This repository has been archived by the owner on Mar 6, 2019. It is now read-only.

shadiakiki1986/reconciler

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

5 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

reconciler

Django app for users to upload pairs of files for reconciliation.

Originally meant for financial institution to reconcile margins on CFDs with their provider.

Installation

  • copy reconciler/settings_override.py.dist to reconciler/settings_override.py and edit as needed
  • ./manage.py test reconciler.core.tests
  • Standard django-fu

Usage

  • go to localhost:8888/admin
  • upload first file saxo_20180627.csv in FileModel
  • upload a second file ffa_20180627.csv in FileModel
  • add a new ReconciliationModel object, and choose file_1 = first file above and file_2 = second file above
  • save
  • The name of the ReconciliationModel object just created will either be saxo... vs ffa...: OK or saxo... vs ffa...: diff

TODO

  • add field "file type" which is a dropdown with choices saxo margin, ffa margin
    • having "saxo margin" would call upon transformations of the original file copy-pasted from Saxo's margin web page
      • drop unnecessary columns
      • modify the "symbol" field to match with FFA's "symbol" field
    • "ffa margin" does nothing ATM
  • continue work on mf-sqlalchemy / export_margin_to_reconciler / main.py to periodically export to here
    • maybe also send an email to FFA's risk department to remind them to export the Saxo margins and reconcile
  • make "ok / diff" more advanced

Changelog

Version 0.1 (2018-07-??)

  • first commit with models and reconciliation based on pandas.assert_frame_equal
  • added notebook showing how to reconcile

About

(WIP) django web app for reconciling positions / margins of different financial institutions

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published