Create a Daily Report.
Grab Data from Multiple Files and aggregate it into one file.
Include the following columns
Strat, PNL, Volume,Markup10,Markup30,Markup60, Markup180,PNL/Volume,Markup10/Volume,Markup30/Volume,Markup180/Volume
Strat Column is in each indvidual file and can be used as a key.
PNL is in the PNL file, please use the 13:30 time column for this.
Volume is in the Volume File, Please use the largest non-zero number
Markup10 ,Please us the 13:30 time column for this.
Markup30, same
Markup60, same
Markup180, same
PNL/Volume, divide PNL/ Volume (In the case there is a divide by 0, you can print nan or 0. instead of #DIV/0!
Markup(all)/Volume, divide Markups/Volume
Please add a Total Row at the bottom. This will total PNL, Volume,Markup10,Markup30,Markup60, Markup180.
I added a template for the desired output.
Hello sir,
I have wide experience of implementing different tools using Python. I'm ready to start right now and will finish in a few hours. As I understand you provided all data to test tool. DailyPNLReport is a result of aggregation.
I'll provide you fully commented code and will answer for any question you have.
Best,
Vyacheslav
$70 USD σε 1 ημέρα
5,0 (5 αξιολογήσεις)
3,4
3,4
2 freelancers δίνουν μια μέση προσφορά $135 USD για αυτή τη δουλειά
Hello, I'm interested in this project, but before I start I have a few questions: do you need the code for this or just a one time merge of files? Also the files that you have given here, are they a real example or just simulated data?