I am in the US and my base currency is the USD. I want to buy 100K Euro of a stock which is denominated in EUR and listed on a European stock exchange. The way my broker (Interactive Brokers) performs the transaction is that it will automatically create margin loan in EUR for me to buy this stock. (...

I am looking for a formula to calculate the weights of two risky assets that produce the optimal portfolio (i.e highest Sharpe ratio). So far I have found the following formula from a website of University of Missouri http://image.prntscr.com/image/190d2f46dbee4b6a8803f23a8e932a53.png However, this ...

Firstly, these should help: http://www.cmegroup.com/trading/interest-rates/files/ics-ratios-2016-09.pdf http://www.cmegroup.com/trading/interest-rates/invoice-spread-calculator.html You can thus compute the spread DV01 of each unit of TUT.  I am not sure where you can get this information for the E...

I currently trading 2/10 steepener or flattener using two ETFs: STPP and FLAT. These ETFs are very illiquid, and I am thinking about switching to futures for the curve trades. My broker, Interactive Brokers, offers a ticker TUT to trade the 2/10 curve with a face value of $300,000 per contract. Now ...

<t>The [HELP] desk simply gave me a search function and let me look for it myself.I tried but couldn't find it, so I was thinking people here may know.The reason why I didn't just create the chart on Fred was because I had a few more charts already created on the Bloomberg monitor page, and I would ...

<t>I found this chart on twitter, which is based on data in Fred.I would like to see if there are tickers that I can use on the Bloomberg Terminal to replicate this chart.I tried to search by the keywords such as "household and nonprofit + mutual fund + asset" on Bloomberg but couldn't find the thre...

<t>I think I have access to the 1 mo Libor rate. So with Libor, 2 yr yield, and 10 yr yield, what would be the simplest approximate formula for 12 month roll down + carry? Being random is all right as long as it's not too far away from actual.(I also have access to yields of other maturities such as...

<t>Hi,Is it possible to use only the 2 year and 10 year generic yields to get a ball park approximate of the net Roll Down + Carry of a 2/10 flattener for the next 12 months?I understand that for a precise calculation we need to use forward yields etc, but if I only need a rough idea of the roll dow...

<t>Hi,I am using the default BDH format in Excel to get the price history of a stock/ETF.However, the series returned is not dividend adjusted (meaning dividends were not reinvested).For example, for ticker TIP Equity, =BDH("TIP Equity","PX_LAST",TODAY()-365,TODAY(),"Dir=V","Dts=H","Sort=A","Quote=C...

<t>Would it work if I remove "Filll=P"?Thanks!QuoteOriginally posted by: MHillIt seems that the "Filll=P" only works for the following calendar month.So for your quarterly series, if your start date is anywhere from 30 Sep to 31st Oct, the value as at 30 Sep will be returned, and carried forward.Usi...

Anyone?Thanks.

Shouldn't the forumla also return the sep30 data for the dates between sep30 to today (when there's no data)?QuoteOriginally posted by: EndOfTheWorldin that case you will get the non NA between today and the 5th of Nov, which is no data

But I remember when I generated this formula I selected "use the last non-N/A value when there's no data". Shouldn't this return me the 30sep11 number?QuoteOriginally posted by: EndOfTheWorldlast price is 30sep11

<t>Yes, because I am writing this spreadsheet on a non-bloomberg computer for someone else whose company has the terminal but he only knows how to use Excel.Please help.QuoteOriginally posted by: bearishThat is very odd. You are working on a spreadsheet that will only work on a computer where a user...

I don't have access to the help desk.Can any one please help?