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.

Evner: Excel, Økonomiske Markeder, Økonomisk Research, Statistikker

Se mere: 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

Om arbejdsgiveren:
( 10 bedømmelser ) woking, United Kingdom

Projekt ID: #4031886

14 freelancere byder i gennemsnit $170 på dette job


Stats experts here!

$210 USD in 7 dage
(23 bedømmelser)

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

$30 USD på 1 dag
(13 bedømmelser)

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

$100 USD in 2 dage
(8 bedømmelser)

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 Flere

$120 USD in 7 dage
(6 bedømmelser)

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

$150 USD in 4 dage
(5 bedømmelser)

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

$160 USD in 3 dage
(1 bedømmelse)

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

$250 USD in 2 dage
(0 bedømmelser)

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 Flere

$250 USD på 1 dag
(0 bedømmelser)

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 in 5 dage
(0 bedømmelser)

hii will be glad to work on this regards bilal

$200 USD in 2 dage
(0 bedømmelser)

Dear Sir, Please check PMB

$195 USD in 2 dage
(0 bedømmelser)

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 Flere

$225 USD på 1 dag
(0 bedømmelser)

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

$85 USD in 3 dage
(0 bedømmelser)

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 in 4 dage
(0 bedømmelser)