Long/Short Portfolio Total Return Analysis

I have an excel spreadsheet containing 66 historical pair trades starting on 11/11/11 up to date. Each pair consists of one long position in a stock and one short position in a stock (one buy name and one sell name basically). I have the relevant buy and sell prices of both when I open the positions and the clsosing prices and their relevant dates. The majority of pairs are opened and closed without any alteration however on some I have doubled or halved the positions befor closing.

What I need is for someone to chart the return of the portfolio since it started versus a benchmark index. It is important to include dividends and stock splits but I can help with these. I don't mind how you generate the figures but I would guess Excel is the most obvious choice.

Kemahiran: Excel, Pasaran Kewangan, Kajian Kewangan, Statistik

Lihat lagi: short portfolio excel, short portfolio analysis, total return portfolio excel, what is a financial analysis, total it, t-short, Return, analysis excel, analysis excel spreadsheet, spreadsheet financial, excel portfolio, excel stock chart, portfolio spreadsheet excel, stock chart excel, excel portfolio stock stock, date analysis excel, stock spreadsheet excel, financial portfolio analysis excel, stock analysis spreadsheet, financial portfolio, excel mind, stock portfolio spreadsheet excel, excel spreadsheet stock portfolio, index prices excel, excel stock analysis spreadsheet

Tentang Majikan:
( 10 ulasan ) woking, United Kingdom

ID Projek: #4031886

14 pekerja bebas membida secara purata $170 untuk pekerjaan ini


Stats experts here!

$210 USD dalam 7 hari
(23 Ulasan)

I am an avid and experienced financial modeller with qualification in finance and statistics. Currently doing PhD in Finance.

$30 USD dalam sehari
(13 Ulasan)

Hi I think I can do this within two days. But, of course, will need more information. Regards

$100 USD dalam 2 hari
(8 Ulasan)

Hi, Its my pleasure to bid on the task you have posted. I a qualified chartered certified accountant by profession ACCA UK and currently working in KPMG Pakistan one of the big 4 audit and accounting firm. My core area Lagi

$120 USD dalam 7 hari
(6 Ulasan)

Hi, I have the experience and professional qualification to deliver this task for you. Please check your inbox for details.

$150 USD dalam 4 hari
(5 Ulasan)

Hi, British female here and expert in financial analysis. Please see PM for further details. Thanks

$160 USD dalam 3 hari
(1 Ulasan)

will deliver in excel, but will user Eclipse BIRT for analysis. you can directly generate up to date chart from now on.

$250 USD dalam 2 hari
(0 Ulasan)

Hi, I am a London Business School graduate specializing in Finance. I have worked with Morgan Stanley previously in the equity research and have done similar analysis before. Happy to discuss this with you! Be Lagi

$250 USD dalam sehari
(0 Ulasan)

I deal with excel on a day to day basis. This is what I do for a living. Please contact me to discuss in more detail

$200 USD dalam 5 hari
(0 Ulasan)

hii will be glad to work on this regards bilal

$200 USD dalam 2 hari
(0 Ulasan)

Dear Sir, Please check PMB

$195 USD dalam 2 hari
(0 Ulasan)

Hi, I am a seasoned Business Analyst in Investment Banking domain and I got the required knowledge and expertise to complete this assignment and would like to ensure you for the quality and professionalism you are exp Lagi

$225 USD dalam sehari
(0 Ulasan)

Hi I clearly understood your project and ready to do it [url removed, login to view] have a look to my PM. Regards

$85 USD dalam 3 hari
(0 Ulasan)

hi i work for an investment bank and i am good at this work, and i have access to bloomberg database which might be helpful in your case. If interested i can complete the work within time frame and with precision.

$200 USD dalam 4 hari
(0 Ulasan)