Mathematics: find a simple formula
Orçamento €8-30 EUR
Hello,
I have the below inputs and formulas.
My end goal would be to find a formula for max_leverage (instead of current value 109) that would enable to have distance_percent / abs(change_percent_price) = cap_percent.
Attached is an excel file with the inputs and formulas for ease of use.
Inputs
max_leverage = 109
risk_per_trade = 100
distance_percent = 0.5%
price = 8000
maintenance_rate = 0.4%
LTV = 102%
cap_percent = 98%
Formulas
amount_risked = risk_per_trade * max_leverage * distance_percent
my_investment = risk_per_trade/amount_risked * risk_per_trade
quan = (my_investment * max_leverage) / price
notional_value = quan * price
maintenance_margin = notional_value * maintenance_rate
collateral = LTV * maintenance_margin
unrealized_pnl = collateral - my_investment
change_price_percent = (unrealized_pnl + notional_value) / notional_value - 1
Concedido a:
Hi, I have written an Excel formula for calculation of "max_leverage". Let’s discuss if you’re interested. Best regards, Duong
20 freelancers estão ofertando em média €20 para esse trabalho
Bonjour, I can help you asap, ...................... send me messageplz to dscussemore thanks ..........................
Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me.
Greeting!. Yours work is one of the tasks that can be done very perfectly by us. We work within your budget, Within your deadline. We are highly experienced Post Graduate Engineers, IT, ITES, Software, Infrastructure P Mais
Hello. Hope all is well. I'm a statistician with a masters degree in statistics and applied economics and am ready to help you immediately. Happy to chat more to exchange details if interested. Thanks
Hello ,h ow r u ,I'm expert using MATLAB AND I CAN DO THIS ON TIME AND VERY PERFECT RESULT!............
____________________________________________________________________ Good at calculations in accounts using excel______________
Hello I'm a statistician engineer with more than 2 years of experience i can help you please check my account contact me
Mathematics: find a simple formula I am a skilled and experienced PhD writer. I can deliver quality documents to tight deadlines with Least prices, I have 8 years of experience in a vast range of exceptional areas, Ple Mais
Hi, I'm an excel expert with hands on experience in advanced formula and mathematics. Please leave me a message to get this done right away. Thank you!
Mathematics: find a simple formula I FEEL, I WOULD BE THE BEST CHOICE FOR THIS PROJECT. PLEASE OPEN MESSENGER AND SEND ME COMPLETE DETAILS, SO WE CAN DISCUSS IT FURTHER. I AM PROVIDING SERVICES IN THIS INDUSTRY FROM 2 Mais
Hello Client, Greetings!! I am Excel Expert with an experience of working in excel for more than 15 years. I will be able to create formula in excel based on inputs. I have already created the formula based on the inpu Mais
Hi, I am a student of PhD and have mathematical and Computer science back ground, I think I can resolve your issue. Please let us chat sometime to proceed with the work. Best Regards
Can be completed in few minutes. Let me know if you need to finish it as soon as [login to view URL] can even use some functions to ease the calculation
Can do it and can submit it by today evening. Have 8 years of experience with administrative job. If you have more similar jobs post it to me. Can work 8+hour in work days and can even work on weekends.
Im electrónic engineer with experience in programming. Also im the manteniance chief in a factory and i do Many graphs with Excel to analice a lot of data
Hello, I can help you in whatever you need, for your formula and the implementation we can talk about it if you want
I’m an engineer from the Philippines. I could take a crack a it. Seems like an easy multilinear problem for me. Update 9/4/20 16:05 I already made your Excel File work to solve this problem
