Bloomberg portfolio exposure help!

This is a discussion on Bloomberg portfolio exposure help! within the Techies Corner forums, part of the Trading Career category; Hey guys! I need some help automating my portfolio: I have about 40 positions. 1/3 pure options. 2/3 stock hedged ...

Reply
 
LinkBack Thread Tools Search this Thread
Old Feb 8, 2012, 4:27pm   #1
 
0 Posts
Joined Feb 2012
Bloomberg portfolio exposure help!

Hey guys!

I need some help automating my portfolio:

I have about 40 positions. 1/3 pure options. 2/3 stock hedged with options. In order to keep myself honest, I manually get the deltas for all my options, and the closing prices of the options and stocks.

After this I calculate the net exposure of the whole portfolio by calculating how long/short I am on each trade I'm in. This is very labor intensive and I'm wondering if anyone knows how I can automate this data processing.

Thanks!
real1g is offline   Reply With Quote
Old Feb 8, 2012, 7:16pm   #2
 
2 Posts
Joined Feb 2012
Re: Bloomberg portfolio exposure help!

It has been a while since I got into calculations so rather than trying to get technical on anything (also considering I never traded options), all I can suggest are some ways you can approach it. Given the subject line of your post I assume you are using Bloomberg as a data provider. The terminal will have its own portfolio grids to calculate this. The most important fact whether you are using Bloomberg or not is that excel is the tool of choice for most people on this. Bloomberg provides an API data service (think it is free), but you need the coding to get excel connected to the streaming Bloomberg data. Best thing to do is call up Bloomberg and ask them to send over the coding spreadsheets. Once you have the code for the data all you need to do is type the correct code into the excel box and the data will start streaming immediately. From here it is pretty simple; with basic excel formulas you can turn the data into whatever you want it to be. You will be able to set all the calculations you do on a daily basis, so it is updating in real-time.

if you are not using Bloomberg...just make sure you have a data stream that can feed into excel and the principal is the same....

anyway... I hope this helps. Sorry I cannot give you the exact excel formulas, but the best place to start is once you have the data feeds on your excel sheet you can get the formulas of the web.
Hebluc is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Similar Threads
Thread Thread Starter Forum Replies Last Post
Bloomberg user forum and Bloomberg automation? mizhael Techies Corner 5 May 22, 2012 4:47pm
Hedging USD exposure in US equities jk451 Forex 0 Dec 19, 2011 6:57pm
Too much exposure and leverage...... forefit Spread Betting & CFDs 5 Apr 17, 2011 11:51pm
LIBOR Exposure/Leverage Calculation Radley Commodities & Money Markets 5 Feb 3, 2009 2:53pm
YM and Dow overnight exposure sirviente Futures & Options 3 Feb 3, 2009 12:47pm

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)