Simulator for historical trades and Excel Automation with Python

Job ID: 39026767

Budget: £20 – £250 GBP

I'm seeking a skilled Python programmer to automate the handling of mixed data inputs into an Excel spreadsheet. Historical trades will be used as a reference point to retrieve data based on a number of conditions and variables from various financial instruments utilising historical data from 2016 onwards. This process will need to be scheduled to complete on weekly and ad hoc basis utilising API connection for historical price capture.

Once the above is completed the same datasets will be used to simulate and output data based on the conditions set out in the simulation.

Some understanding of trading terminology and bar/candle charts would be useful as this will would make it easier to comprehend the conditions and variables but is not a pre-requisite.

Key Requirements:
- Develop a market simulator that will facilitate backtesting of historical trades.
- Use Python for automation of Excel and handling mixed data.
- API connections with Java and Python

Ideal Skills and Experience:
- Strong experience in Python, particularly with data analysis and Excel automation.
- Familiarity with various financial markets and backtesting methodologies.
- Good and clear communication skills.

I look forward to your bids.