Datastream Newsletter Q1 2012
February 23, 2012New in Compustat Wharton WRDS : Capital IQ
February 7, 2012UvA has bought access to Capital IQ (Equity debt structure) in Compustat in Wharton WRDS. As a UvA student or employee you can register for an account on the Wharton WRDS homepage.
Country sovereign ratings Moody’s Fitch S&P
February 3, 2012See attachments for historical overviews
Sovereign Master Rating HistoryMOODY’s
sovereign_ratings_historyFITCH
New in Datastream Economics: Oxford country data forecasts 2036
January 27, 2012Oxford Economics Forecasts
International macroeconomic forecasts are now available from Oxford Economics, a leading consultancy firm with ties to Oxford University. The new dataset includes over 90,000 series providing key indicators of macro, financial, and socio-economic trends. Annual forecasts are given for 200 to 400 series for up to 190 countries and quarterly for 45 principle developed and emerging markets. Many indicators are presented in common terms for comparability across countries.
Data are projected to 2036. Oxford Economics combines detailed country analysis by their experienced economists with the rigor and consistency of their highly regarded Global Model to produce estimates of unparalleled reliability. Updates will be provided each month. Historical data start in the 1980’s and are taken from original primary sources for the majority of concepts, supplemented with financial and debt data from international organizations.
Headline and major macroeconomic series are provided for all countries. Availability varies for the more detailed and analytic series.
Average of 3 months to make it quarterly in Excel
January 27, 2012Question: How can I repeat the average of 3 cells (months) over a whole column to easily get quarterly figures?
Answer:
- Use the Average function for the first 3 months
- Copy the formula of C1, CTRL C
- Set your cursor in the cell where the second quarter is supposed to be, C4, and CTRL V to paste
- Now select both concepts, 2x the cell with the average and two empties. C1-C6.
- Now drag down
- et voila…merci
Calculation of two datatypes in Datastream
January 26, 2012Question: Can I do a calculation in Datastream of two datatypes before pressing Submit so that I get the result of the calculation in my results sheet?
Answer: Yes. Within one particular formula you can enter two datatypes in the Datatype field of the Time series.
Let’s say you want to divide WC04049 by WC02999. You can enter it as follows in the Datatype field:
DPL#(X(WC04049)/X(WC02999),6)
Where 6 is the number of decimals you want in the result.
Before clicking Submit you have to check: 1st series. Under the Display expression.
New EBooks #7
January 20, 2012
Datastream newsletter Q4 2011
December 1, 2011
Springer EBooks Economics and Business 2005-2011
November 25, 2011The UvA library has purchased a huge collection of ebooks from Springer Verlag on the subjects of economics and business. Users with a uva-net id now have access to over 5000 titles from 2005 till 2011.
Springer economics and business ebook collection
Historical components of AEX
October 18, 2011Attached you find a Excel file containing most of the companies that have been listed on the AEX since 1984. When you use the LAMSTEOE in Datastream you only get the 25 companies that are currently listed on the AEX. If you use attached file and select the given mnemonics, you can search the given 54 companies at the same time.
