Find Jobs
Hire Freelancers

Create a google sheet template with compounding by date

$10-30 USD

Completed
Posted about 3 years ago

$10-30 USD

Paid on delivery
I have CSV file of trading stats. These stats have date on them. I need a template to add a starting amount X and calculate the daily return with a compound effect over the initial amount. For this, we will need a new column that calculated ALLOCATED % * NET PROFIT % Then from that new column, we would calculate the return on a daily basis over our initial amount. I would also need another column that would give the % return of each rows vs the initial amount. See the attach file to know what I mean. It is important that the results are compounded in daily close batch to keep the results as accurate as possible. Or if you have a better way, I am open to it. I am worried that for example: 3 trade open with amount 100 the first one close with 10% profit so now the amount is 110 then the second close at 10% so the new amount is now 121. But those 2 trade were open at the same time meaning that the second one wasn't using 110 as starting equity, but 100$ also. So the result should be 120 after they both close. I don't even know if it is possible to do, you let me know
Project ID: 29464359

About the project

10 proposals
Remote project
Active 3 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
$0 USD in 1 day
5.0 (1 review)
1.0
1.0
10 freelancers are bidding on average $27 USD for this job
User Avatar
Hi, I am well versed with Google sheet as well as Excel. I went through project description. It would help to discuss further on the requirement as I have few queries. Looking forward to you response. Thanks
$50 USD in 3 days
4.9 (43 reviews)
5.7
5.7
User Avatar
I have read your project details and can do Create a google sheet template with compounding by date as per the requirements. I will give you quality work. I have more than 10 years of working experience in the industry. I am producing quality content for my clients including; ARTICLE WRITING, ESSAY WRITING, RESEARCH PAPERS. I can provide you 100 percent quality even in a short period. I can assure you, "You will hire me again and again after getting my first service". https://www.freelancer.com/u/assignsolver.
$10 USD in 1 day
4.7 (55 reviews)
5.7
5.7
User Avatar
Hello there, I will help with the project on Create a google sheet template with compounding by date. I have read the instructions carefully and I clearly understand what is required of the project. I have handled several assignments in this field and I will be glad to offer my expertise and on this one too. With me, the quality and the deadline of your paper are my utmost priority. I have the expertise needed to complete your project as i have skills in Statistics, Data Processing, Accounting, Statistical Analysis and Excel. Feel free to contact me for more details.
$29 USD in 1 day
4.9 (30 reviews)
5.0
5.0
User Avatar
I have extensive amount of experience in Excel, Formulas, Data Entry, Excel, Internet Research, Research, Web Search, Lead Generation, email listing, Data Mining Project Emails. Please take a look at my profile and reviews to get an idea about my work. I would like to work on this project and can complete with 100% accuracy within the time frame. Quality is assured. “Waiting for your reply”. Kind Regards, Batairy
$30 USD in 1 day
5.0 (42 reviews)
5.1
5.1
User Avatar
Dear Client, I have seen your posted job on freelancer and i feel very much interested to work with you. I have read the things that you want. I consider myself perfect match for the job because I am confident I can exceed your expectations. I can complete your project on time and within your budget.
$10 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi there, I am a professional and expert major in data analytic with addon other skills such as editing, mathematics, writing, research, and data entry from Malaysia. I am very fast at writing and I follow all you require for this. I'm a well-skilled and hardworking data analytics and editing who completes and makes every given project successful. I will provide you with professional and high-quality service with the best time frame. However, I have read the job details carefully, as you stated in the description, but I think it’s important to know the full details before writing anything, feel free to contact me at any time, and looking forward to your response. I can assure you that your job will be done perfectly at the right time without making any mistakes. So if you feel interested, have faith in me and give me a chance to make your project successful. I will be glad if I can assist you with your project. Please have a look at my profile for being sure about my background and my skill. ** https://www.freelancer.com/u/ermannazra98 ** Thank you Best Regard, Erman Nazra
$30 USD in 1 day
5.0 (1 review)
0.0
0.0
User Avatar
my work is very serious and dynamic, I am punctual and fast I can help you very well in this job I have a lot of experience in accounting I am an accountant with 10 years of experience, I would like to work you thank you. and also there is an example on my portfolio of a project that I did here on this site: balance sheet + general balance.
$20 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I create good looking and successful spreadsheets. Your task looks straight forward and there'll be clear formatting
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of CANADA
, STE-MARTINE, Canada
5.0
40
Payment method verified
Member since May 28, 2013

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.