Closed

Options track record - 5 year detailed P/L and risk/return

The job: Calculate detailed track record results and risk/return data from a five year + options trading track record.

Must be very knowledgeable about complex options strategies including vertical credit and debit spreads, iron condors, strangle/straddles and other strategies or the learning curve will be much too steep (trust me!). Some positions involve multiple legs which have to be considered in the calculations and final track record documentation. Much of the initial work has been done for the first four years, but it needs a review and confirmation.

Detailed Knowledge of options strategies' profit and loss calculations is more important than excel proficiency, but both are needed.

Ability to calculate and graph other risk/return metrics from raw data such as sharp ratio, sterling ratio, maximum draw-downs, etc. is preferred, but if you are just an expert in options P/L and excel and can give me the percentage return data for different periods and combined total, that's fine.

After the initial project, would like to have a front-end that allows forward P/L calculations to be automatically updated with simple data input going forward.

Access to historic options data also a plus.

Skills: Data Processing, Excel, Finance

See more: options track record, excel options, to p, graph sharp, first trust, first graph, end year review, year, track credit, sterling, spreads, return, options, metrics, iron, historic, final years project, final year project, data p, c p, calculate different, risk excel, detailed review, front end plus, knowledge excel plus

About the Employer:
( 1 review ) Palm Beach Gardens, United States

Project ID: #567022

21 freelancers are bidding on average $295 for this job

NashTrump

Hi, I am a freelance programmer with over 11 years experience in VBA, Excel, MS Office, Perl, PHP, Mysql and SQL. I am an expert web scraper and data automation. I hope you find my experience and bid agreeable More

$100 USD in 1 day
(15 Reviews)
4.6
crajeshbe

Hi Good day, Forex programmer Bid. I already did similar type of Calculators such as Option Calculator, MTM calculator, FRA, VAR, strangle, straddles and so on. Need more details to get started.

$500 USD in 5 days
(7 Reviews)
3.7
frehmanpk

Respected Sir, I m continuously involved deleloping Multi User, Secure and User Friendly solutions for my clients having a small business. On the other hand I m a .net developer but I prefer MS Access based solutions More

$1000 USD in 5 days
(5 Reviews)
2.5
jomuna

A warm and pleasant heartily greetings from the jomuna. I am a part of the major group translation in my country. I am highly skilled and diligent. I assure best pricing, time line and hard worker. I work basically tra More

$50 USD in 3 days
(1 Review)
0.0
omshanti108

I am a MBA in Finance. I would love to do this project.

$200 USD in 3 days
(0 Reviews)
0.0
Shikha80in

Hi, I am an MBA(Finance) with corporate experience in structured finance analysis and business reserach. I am very comfortable with excel modelling as well as have knowledge about returns calculations, capm, basic opti More

$250 USD in 7 days
(0 Reviews)
0.0
blackrockconsult

Dear sir or madam: We are a member firm of CPA Associates International Inc. (known as Nasir Javaid Maqsood Imran) and have more than 28 years experience of Data entry, Bookkeeping, Audit, Tax and related services. More

$100 USD in 10 days
(0 Reviews)
0.0
hanifgillani

I can done your project in given time if you are interested to give me this project. you can contact me by PM. i am waiting for your reply

$150 USD in 10 days
(0 Reviews)
0.0
mongkolchon

I work in a Thai securities firm. 7-year investment and excel exp. should be qualified.

$100 USD in 7 days
(0 Reviews)
0.0
dilipjai

I am very much comfot in Excel and able to make many types of MIS according to requirement. I have already made many spreadsheet,which provides results on the base of farmulas and programming.

$250 USD in 25 days
(0 Reviews)
0.0
Mendisjoachim

I am a qualified accountant having more 20 yrs experience in this field.

$500 USD in 45 days
(0 Reviews)
0.0
sailu111cw

Hi! I have gone through your requirement and i am glad that i can accomplish this task, i would be more interested to speak to you on IM. Pls give us an opportunity to work with you.

$30 USD in 2 days
(0 Reviews)
0.0
sailu125cw

Hi! I have gone through your requirement and i am glad that i can accomplish this task, i would be more interested to speak to you on IM. Pls give us an opportunity to work with you.

$30 USD in 2 days
(0 Reviews)
0.0
mahendagarwal

The total project cost estimated by me should be around 350$.I have a clear cut knowledge of the option strategies as i have done explicit study on options and its greeks.I do research and analysis on companies with th More

$350 USD in 15 days
(0 Reviews)
0.0
poojapatel22

Please check PMB.

$200 USD in 5 days
(0 Reviews)
0.0
vkohli

I have over 3 years of extensive research in derivatives. I have implemented numerous strategies such as Butterflies, Strangles, Straddles, and Condors. My specialties are in determining the prices of options according More

$250 USD in 3 days
(0 Reviews)
0.0
mmikeman41

I'm an Equity Options Trader on the floor of the CBOE for the last three years with an advanced degree in Computational Finance. I'm new to this site but this is a project I could comfortably finish in two days for yo More

$200 USD in 2 days
(0 Reviews)
0.0
Mitshel

If you need this work professionally and effectively done, please consider the following about my background: Former Stock/Options Broker Extensive Excel consultancy experience MBA in finance and systems More

$1500 USD in 5 days
(0 Reviews)
0.0
accountspro

Hi, I can do this. Let me know if you want me to do it. Accountspro

$250 USD in 10 days
(0 Reviews)
0.0
kvkrishna

for the above project,we can conclude it in 28 days with 99% accuracy.

$70 USD in 28 days
(0 Reviews)
0.0