Find Jobs
Hire Freelancers

Create Daily Report

$30-250 USD

Completed
Posted over 9 years ago

$30-250 USD

Paid on delivery
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.
Project ID: 6479450

About the project

2 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 in 1 day
5.0 (5 reviews)
3.4
3.4
2 freelancers are bidding on average $135 USD for this job
User Avatar
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?
$200 USD in 5 days
5.0 (3 reviews)
2.7
2.7

About the client

Flag of UNITED STATES
Methuen, United States
5.0
4
Payment method verified
Member since Aug 28, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.