dmpe
commented
6 years ago -
[x] Be able to download and parse data in pandas df/numpy array
- [x] CZK/USD: CSOB
- [x] EUR: https://pandasdmx.readthedocs.io/en/latest/usage.html#connecting-to-an-sdmx-web-service-caching
-
[x] show some 2 (eur/usd and those with CZK) graphics/tables with those currencies
- [x] prepare a model that can be used to display data right on the exchangerate page
- [x] Testing ok as of https://github.com/dmpe/django-wohn/commit
- [x] fetch data from database and return the query via javascript graphic 86331607840ba819f3a69feb2eb985a7f563be26 --> now wire it together with the table data
-
TO BE DONE LATER - ELSEWHERE - associate exchange rates with some business logic, e.g. how to calculates the final prices
Sources: https://www.highcharts.com/samples/data/aapl-c.json https://www.highcharts.com/samples/nonav/stock/plotoptions/series-compare-percent https://www.highcharts.com/docs/chart-concepts/series https://djangobook.com/django-models-basic-data-access/ https://stackoverflow.com/questions/11743019/convert-python-datetime-to-epoch-with-strftime https://docs.djangoproject.com/en/2.1/ref/contrib/admin/#django.contrib.admin.ModelAdmin.changelist_view
Parse in pandas/numpy and create EUR/CZK/US Dollary table below - all combinations - CZK is base
Sources of raw FOREX data https://www.cnb.cz/cs/financni_trhy/devizovy_trh/kurzy_devizoveho_trhu/denni_kurz.jsp https://www.cnb.cz/cs/financni_trhy/devizovy_trh/kurzy_devizoveho_trhu/denni_kurz.txt https://www.csob.cz/portal/lide/kurzovni-listek/-/date/kurzy.txt
https://www.ecb.europa.eu/stats/policy_and_exchange_rates/euro_reference_exchange_rates/html/index.en.html https://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml
For considerations: https://github.com/izimobil/django-rest-framework-datatables maybe
URL inspirations https://medium.com/@hakibenita/how-to-turn-django-admin-into-a-lightweight-dashboard-a0e0bbf609ad https://medium.com/@hakibenita/how-to-add-custom-action-buttons-to-django-admin-8d266f5b0d41