Create a google sheet template with compounding by date

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

Skills: Data Processing, Statistics, Statistical Analysis, Accounting, Google Sheets

See more: create sell sheet template company, create sheet template excel, create sell sheet template, sign up sheet template google docs, how to create an automatically updating google sheet, google apps script create document from template, create form from google sheet, line sheet template google docs, google cloud create instance from template, create google form from google sheet, sales sheet template google, google sheets api create new sheet, profit and loss balance sheet template, cash flow profit and loss balance sheet template, how to create google sheet in gmail, how to create google sheet, create google form template, google sheet template, how to share a google sheet template, create google sheet as template

About the Employer:
( 40 reviews ) , STE-MARTINE, Canada

Project ID: #29464359

Awarded to:

(1 Review)

10 freelancers are bidding on average $27 for this job


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
(43 Reviews)

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 industr More

$10 USD in 1 day
(55 Reviews)

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 seve More

$29 USD in 1 day
(30 Reviews)

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 rev More

$30 USD in 1 day
(42 Reviews)

Hi there, I’m ready to work for this project because its matches my expertise, which is over five years of experience as an expert data entry operator. My typing speed is 60 wpm also assure you that I will complete th More

$15 USD in 1 day
(0 Reviews)

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 e More

$10 USD in 1 day
(0 Reviews)

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 requ More

$30 USD in 1 day
(1 Review)

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 y More

$20 USD in 7 days
(0 Reviews)

I create good looking and successful spreadsheets. Your task looks straight forward and there'll be clear formatting

$30 USD in 1 day
(0 Reviews)