I need to pull historic yields for a bunch of different indices... Ive been on bloomberg for the last 45 minutes with no luck. Specifically, Im trying to get 5yr, 10yr, 20yr, and 30yr for each of the following:
Munis: AAA GO AA GO A GO BAA GO and Insured
I can get the current yields but I don't know how to get all yields from April '08 to July 30 '08.
A little help please.
AAA Muni YA Go
will pull up yield analysis page where u can input dates and find the yield.
45 minutes? jesus.. couldnt you just ask someone in the office to help?
Thanks buddy. What about insured?
dont know about insured. just get to the summary page for the bond and then hit "YA GO" and it shud bring up the yield analysis page
That shows me the current yield curve... I need to see those represented numerically and I would need it for every Tuesday from 4/1/2008 to now.
How would I get there?
have you tried Help Help?
Yup, they were actually very helpful... ended up just using Bloomberg API in Excel and got all the data I need and some.
God bless HELP HELP.
You wouldn't say that if you had actually asked them a non-trivial question. I could post chat transcripts that would make you jump.
I'll help you out. PM me your name on Bloomberg.
Yeah try help. Otherwise just lookup bloomberg shortcuts online. You should just be able to type in AAA and then the menu will populate with different options.
www.sharpeinvesting.com
"You wouldn't say that if you had actually asked them a non-trivial question. I could post chat transcripts that would make you jump."
seconded.
thirded. bbg help is good for simple questions about getting charts or simple bbg functionality. but if you have specific questions about how bbg handles product data, be ready for a disappointment.
hahaha I'll be fourth to request this!
Well, there is this sytem i discovered a few years ago (die hard bloomberg user 10 years previous to my little discovery). anyway, the system i use for charting, analaysis, order routing and market news is called CQG. When I have a problem, I ring up and I actually get real help! Anyway, the system is so much cheaper than Bloomberg is..i think they are around 300 pounds/month.
Check them out. www.cqg.com
regards, nick leeson ;-)
CQG is the shit
this is what i call constructive criticism...NOT!
"please do. that would be interesting"
We'll see. There may be compliance issues.
"Well, there is this sytem i discovered a few years ago (die hard bloomberg user 10 years previous to my little discovery). anyway, the system i use for charting, analaysis, order routing and market news is called CQG. When I have a problem, I ring up and I actually get real help! Anyway, the system is so much cheaper than Bloomberg is..i think they are around 300 pounds/month.
Check them out. www.cqg.com
regards, nick leeson ;-)"
First off, there is a reason CQG is much cheaper than Bloomberg: CQG doesn't have nearly as much functionality. There are no desktop/server APIs to speak of, let alone proper data for international securities, to mention two amongst a list of hundreds. If you are fully leveraging the power of Bloomberg, CQG will seem like a joke to you. Anybody with minimal programming/database experience could buy data feeds off of the relevant exchanges and build a CQG type app in a few months. Try doing that with Bloomberg.
Also, is cost honestly an issue? In what area of finance does $560(£300)/mo vs. $1800/mo. actually make a difference?
I make fun of the Bloomberg help desk as much as the next guy, but at the end of the day, Bloomberg Professional is a system without peer.
Well, they actually do have an API, as well as hosted blackbox solutions and co-located solutions at the exchanges.
As far as cqgs charting goes, its second to none. you can trade straight from the chart, they have tons of studies (which can also be customised) and much more. (Like market scan, depth of market, trading from conditions etc)
Bloomberg can also not really be compared to cqg, cause they are not a trading platform. They are what they are. With cqg you can trade, you can analyse data, you can backtest and again, they actually help you if you need help!
And in regards to your comment on the pricing side of things...lets say you find an envelope filled with $1000...would you not pick it up and welcome it? Regardless, how rich you are...
Bloomberg has its advantages, but they are everywhere...and personally, I welcome competition...and to me cqg is a healthy alternative to bloomberg.
Nick L.
PS. Having said all this, have you ever tried anything else but bloomberg? (Or even cqg?)
Sit et temporibus qui atque atque perspiciatis eos explicabo. Cupiditate voluptatem hic voluptatibus praesentium. Occaecati possimus cum dignissimos odio.
Officia qui laborum et vero amet et voluptatem nulla. Reprehenderit eos inventore rem provident et.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...