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.
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!
Best,
Anirudh
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 expecting from this assignment. I complete this kind of assignment on daily basis. Please go through my completed projects and portfolio to verify the same. I am looking forward to hear from you.
Regards
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.