Excel Calculator
$10-30 USD
Paid on delivery
Hello
I need a freelancer who can create a Excel based algorythmen Calculator that way that we can just change the numbers of the 3 Levels and it does the math.
Explain:
The Calculation should be that we basically have 3 Level that we of course can adjust for primary Calculation:
Level 1: Long Targets
Level 2: Recovery Zone
Level 3: Short Targets
Basically our goal would be that we can put any number into each level and it should Automatically Calculate up to 30 Following Trade sizes. Trade Sizes would been indicated or Calculated that every time we will hit our Long or Short Target that we generating 20Pips Profit.
Example: First Trade 1Lot we don`t hit our Target and it drops under our Puffer Zone Limit a Short Trade is opened so (1Lot = 200Pips loss + 1.4Lot*150Pips win = 210 win(210win Pips - 200Loss Pips = 10 Pips Profit) if we will hit one of our Final Target of 150Pips of course we will lose one Trade but the second we win in total by changing the sizes individual we still make a profit.
It is a bit hard to explain but we need a Excel Template Calculator that Calculate on Auto them up to 30 (15 Long and 15 Short) different Sizes for each purpose that we when ever after don`t care as much Long and following short Trades we always when we will hit a Final Target making Between 10-20Pips Profit or the best would be ever 20Pips Correctly. Of course we would like to go always on half number like 13.333 would be 13.5 and 8.1 would be 8.5 ever up never down.
Why we ask you because we just could not get a proper Calculation or Mathematical way to the right result but maybe you find the right <<calculation for this. Just don`t forget by the Calculation that we need a Excel Template where we can change the Final Profit Levels and as well the Puffer Zone Pips as well the Template should Calculate always the same Final Profit of 20 (or whatever number we type in) so it could be also look like that: (Final Pip Target for Long and short 50Pips and the Puffer Zone is 150Pips Wide). And of course it should be possible to choose between Lot, Mini Lot and Micro Lot sizes as well that it Calculate the .0, .00 as well.
If you think you can do this Please send me a Quotation for this Job and we will check it and get back to you
Thank you
Please just bid if you know the Math and the calculation!
Project ID: #7232997
About the project
Awarded to:
Dear, Regarding my qualifications, I hold a Master's degree in Electrical Power Systems and a Bachelor's degree in Engineering (Electrical) and I've been using Matlab/Excel/VBA for 5+ years. Regarding The project: I More
17 freelancers are bidding on average $46 for this job
Dear Sir I can accomplish the job for you. I have carried out projects related to excel in the past successfully. I ensure of completing the task within the time specified. Kindly contact me for further details. Th More
Hi, I am a Mechanical Engineer with a first class honors degree. I can complete the task accurately within the time you specify. You can check the reviews I got for my previous projects to get an understanding of the More
I have very good solution developed for such projects, ones that require multiple conditions covered. You can see my portfolio and reviews, contact me if you are interested. Thanks
Hi, excel vba expert here ready to start, let me kno when we can discuss it, I assure you high quality work done. Regards.
I'm an excel expert and make customized spreadsheets for my customers. I will need more explanations about the things you need to be calculated but it will be really easy for me. I will start right away
Hello sir, I am interested in your project and I would like to develop this excel calculator, I am experienced in excel vba programming. I just want to know the requirement in more detail so let's chat more to discuss More
i will do it in 2 days i have skills on excel programe and i will calculate the project information and thanks
I have read your instruction. I have done similar job for my thesis work. i can do it . Let me know if you r interested.
Expert in Excel and Maths can do this task efficiently. Ready to start. Waiting your response. Thanks.