Ⅰ 求助bloomberg彭博数据库
具体VBA怎么写我不清楚。但是你不能写的原因和函数本身有关。这个函数是取决于有效天数的，那个"cols=2;rows=62"是在定义了excel的函数之后bbg自动加进去的。你把那两个删除了试试。
Ⅱ 波罗的海海运指数BDI的历史数据
http://www.investmenttools.com/futures/bdi_baltic_dry_index.htm
这个网址具有详细的BDI的各类信息,是免费的不过就是英文界面
Baltic Exchange Dry Index (BDI),
4/22/08 Queues at the Panama Canal are becoming longer. About 90 ships are waiting to get through the Canal, doubling transit times to a record 53 hours from the usual 27 to 30 hours.
4/2/08 Weak dollar boosts Long Beach (CA) exports 36%, but cuts imports 7.6% in February.
2/4/08 China is building an enormous logistics facility covering nearly 70 hectares for the newly-launched Sino-Germany Container Railway. It is predicted that the volume of Germany-bound boxes on this railway will reach 20,000 to 26,000 TEU by 2010 while Beijing-bound boxes will be about 10,000 TEU.
1/11/08 Baltic dry sea freight index makes record fall Dry commodities trading analysts have so far attributed the steep pullback from the all-time high hit last November to a correction at the top of a white-hot market and an expected seasonal downturn in shipments in the first quarter.
12/19/07 Shangyu port is planning new terminals with total annual capacity of 10 million tons. Capacity of the new port will be 40 times larger than the present Shangyu facility, which can accommodate 3,000-tonne vessels and handle 245,000 tons of cargo a year, Xinhua reported.
12/11/07 Rongcheng’s cargo volume for foreign trade grew 78% YoY
12/6/07 YoY Oct. traffic at major US container ports fell 3.5%.
12/5/07 Shipping chief warns of ‘insane’ charter rates
One of the biggest operators in the booming dry bulk shipping market has warned that conditions where charter rates for ships have nearly tripled in a year, were “insane” and “unsustainable”.
9/4/07 Panama begins canal expansion: The $5.25-billion expansion will accommodate a new class of huge ships capable of carrying more than twice the number of containers as the vessels that currently transit the waterway. Completion is set for 2014 to coincide with the 100th anniversary of the inauguration of the original canal.
6/26/07 Shares of COSCO, Asia's largest container line, as much as doubled Tuesday on their Shanghai trading debut.
5/25/07 YoY goods shipped by truck in the U.S. fell by 2.7 percent in April.
Container volumes on the Asia — Europe trade rose 20% in the first four months of the year.
5/22/07 The handling capacity of China's ports is expected to hit 8 billion tons and 170 million TEUs (twenty-foot container equivalent units) in 2010. The cargo handling capacity of all China's ports totaled 5.6 billion tons and 93 million TEUs in 2006.
4/30/07 China Shipbuilders, Rivaling U.S. in WWII, to Cut Freight Costs April 30 (Bloomberg) -- The cost of shipping coal and iron- ore is about to decline as the supply of cargo vessels overwhelms demand. Japan, China and South Korea will proce so many vessels that shipping costs, now at an all-time high, will fall 40 percent by 2010, according to futures contracts traded privately between banks, transportation companies and hedge funds.
1/16/07 YoY November air cargo shipments rose 2.9% , the Air Transport Association said.
12/28/06 American Trucking Associations’ seasonally adjusted truck tonnage index dropped 3.6% in November, following its 1.9% drop in October.
12/12/06 The number of trucks in use in the U.S. is down 0.6% in the third quarter, a sign expanding hauling capacity by carriers may have peaked.
8/22/06 Hong Kong's port transshipment cargo recorded an average annual growth rate of 12% from 2000 to 2005, the Census & Statistics Department says.
8/15/06 China's ports post 22 % growth According to a Xinhua report, ring first half of 2006, China's major sea and river ports together handled over 42 million TEUs posting a growth of more than 22 percent.
6/23/06 Panama's Congress will debate next week whether to push ahead with an ambitious and costly plan to expand its canal.
4/3/06 The tiny biodiesel instry received a boost from Big Oil on Monday when a major petroleum refiner, Motiva Enterprises LLC, began blending the soy-based alternative with traditional motor fuel at a Dallas terminal
2/17/06 Class 8 truck orders in North America are off to a roaring start in 2006, with January’s total reaching an all-time monthly high of 43,100 units.
2/15/06 Overall air cargo shipments rose 1.3% in December from a year earlier, but domestic shipments dipped, the Air Transport Association reported.
1/19/06 Shipping Rates for Coal, Ore Fall to Five-Month Low on Supply
The cost of shipping commodities such as iron ore and coal fell to its lowest in more than five months because of a builp of vessels available for hire in the Pacific and Atlantic Oceans.
12/27/05 Overall for-hire trucking freight volumes surged 1.9% in November from a month earlier, American Trucking Associations said Tuesday.
12/20/05 The average retail prices of diesel and gasoline each rose for a second straight week by 2.6 cents, with diesel climbing to $2.462 and gasoline to $2.211 a gallon, the Department of Energy reported.
U.S. Sales of Class 8 trucks jumped 16.6% in November as truck buyers took delivery in a market where freight rates remained strong and truck proction showed no signs of letting up, manufacturers said.
11/30/05 Overall for-hire trucking freight volumes rose 0.3% in October from a month earlier, the American Trucking Associations said.
11/27/05 Shipping lines raise charges by 12pc: Effective Dec 1, 2005
Justifying the move, the ‘notice to trade” points out that all member lines are facing considerable increases in charter rates that continue rising dramatically. It also attributes the hike to a worldwide shortage of container equipment.
11/20/05 Global shipping: Challenges ahead As on January 1, 2005, the world trading fleet was made up of 46,222 ships, with a combined 597,709,000 gross tonnes. The vast bulk of the fleet was made up of: general cargo ships (18,150), tankers (11,356), bulk carriers (6,139), passenger ships (5,679) and container ships (3,165). Other ship types accounted for 1,733 vessels.
11/18/05 The United States and the European Union reached a tentative deal on Friday expand aviation service and boost competition on both sides of the Atlantic
11/15/05 The average U.S. retail price of diesel fuel fell for a third straight week, dropping 9.6 cents to $2.602 a gallon, the Department of Energy.
The Panama Canal Authority’s largest customers are forecasting a 12% increase in traffic between Asia and the US east coast in 2006 as trade between the US and China shows no sign of slowing.
10/28/05 Surface trade amid the United States, Canada and Mexico rose 12.3% in August from a year earlier to a total of $60.2 billion, the highest monthly level ever recorded, the Department of Transportation reported Thursday.
10/27/05 U.S. monthly retail sales of Class 8 trucks rose by 16.3% over last September’s level to 21,677 units, YoY the 23rd straight monthly increase.
10/13/05 A Crisis could be threatening for world shipbuilders investment banker Morgan Stanley warned that overcapacity in the instry could be as much as 30% by 2008.
10/06/05 Domestic air cargo shipments rebounded from a 5% drop in July to climb 0.6% in August in year-over-year comparisons, the Air Transport Association reported Thursday.
09/13/05 The cost of shipping commodities such as iron ore, coal and crude oil is poised to rise through the rest of this year as Chinese steel mills and refineries increase imports, according to shipbroker Lorentzen & Stemoco said, Bloomberg reports .
09/12/05 The container throughput of the Shanghai Port increased by 27 percent year-on-year
08/30/05 Surface trade among the U.S., Canada and Mexico rose 7.2% in June to $59.4 billion from a year earlier, the Department of Transportation reported.
08/29/05 With the peak shipping season in full force, intermodal container traffic for the week ended Aug. 20 was the highest week ever on record, the Association of American Railroads said.
08/22/05 Boom and bust at sea
08/16/05 Port of Long Beach: Junes Asian imports at the second-largest port in the U.S. pushed overall volume to 576,604 TEUs from 494,098 TEUs a year earlier, according to the port's preliminary data.
08/01/05 Ocean freight continued weak, taking gulf to Japan back to $34 a ton, which is the lowest rate in almost 30 months.
07/26/05 The average retail price of diesel fuel fell for a second straight week, dropping 5 cents to $2.342 a gallon, the Department of Energy said Monday.
07/26/05 U.S. sales of Class 8 trucks jumped 38.2% in June from year-ago levels, and reached their highest monthly total since December 1999, as fleets’ buying spree continued.
06/22/05 The long-haul, heavy-ty truck transportation instry in the United States is experiencing a national shortage of 20,000 truck drivers, the American Trucking Associations reported
06/22/05 COSCO, China's biggest shipping conglomerate has found hesitant interest by retail investors in its $1.65 billion IPO on worries that the global shipping boom has peaked.
06/20/05 he Singapore Exchange has confirmed plans to develop a clearing house for freight and energy derivatives as the country looks to capture more of the growing Asian market.
06/20/05 US rail carloads totaling 332,491 units decreased 2.2 percent the week of June compared to the same week in 2004.
06/20/05 Despite ongoing demand running ahead of capacity faltering Charter rates and new ship prices could be a sign that the three-year rally in box shipping is leveling off.
06/12/05 Ocean-freight rates fall as global demand slows for some commodities Surging demand and a shortage of ships pushed freight rates to record highs in December. But since then, the Baltic Dry Index,..., has fallen by more than half,....
06/08/05 Cruise Lines International Association (CLIA) carried 2.63 million worldwide guests in the first quarter of 2005, an 8.9 percent increase over the same period in 2004. North American passengers grew by 12.9 percent ring the quarter to 2.34 million guests, up from 2.10 million first-quarter guests one year ago.
06/08/05 Shares of a handful of major truckload firms fell Wednesday after analysts from the firm Bear Stearns & Co. lowered ratings on several trucking stocks, citing a slowing business environment, falling demand and higher costs, the Associated Press reported.
06/07/05 Total air cargo shipments rose 0.3% in April compared with a year earlier, following a 3.1% year-over-year drop in March, the Air Transport Association reported.
06/01/05 Growth in the world’s tanker fleets is outstripping demand, forcing charter rates down to new lows and putting pressure on shipping company share prices – Lloyd’s List reports.
05/26/05 YoY New York Customs District saw overall air-cargo tonnage increase 1.67 percent in March.
05/12/05 Bullish outlook for FedEx ..FedEx reiterated that it expects profit to range between $1.40 per share to $1.50 per share for the fiscal fourth quarter ending May 31.
05/09/05 Amid rising gas prices, makers warm to diesel cars Diesels use 20 percent to 40 percent less fuel than comparable gasoline engines. And diesel fuel coming to market starting this year will have lower sulfur content, recing emissions dramatically.
05/09/05 Total air cargo shipments rose 3.1% in March compared with a year earlier, following a 1.3% year-over-year drop in February, the Air Transport Association reported.
05/05/05 The tanker market is likely to be the first shipping sector to suffer an oversupply of tonnage, leading to earnings declines for the next three years, Citigroup Smith Barney tanker analyst John Kartsonas has warned.
05/05/05 International trade through the Los Angeles region will grow by more than 14% this year to a record $302.1 billion, according to an economic study released Wednesday, the Associated Press reported.
05/04/05 Transport costs between Richards Bay, which has the world's largest coal export terminal, and Rotterdam dropped 7.2 percent last week to $18.62 (R114) a ton.
04/27/05 Overall trucking freight volumes fell 3.3% on a seasonally adjusted basis to 111.6 in March, according to an American Trucking Associations index released Wednesday.
04/26/05 Rates for very large crude carriers have peaked and are unlikely to match the euphoric highs seen last year, says Helmut Sohmen, owner of World-Wide Shipping.
04/26/05 China has announced further container terminal expansion by giving the go-ahead for a 2.5m teu facility at Shenzhen, the world’s fourth largest box port city.
04/22/05 During week of April 16th Tonnage Volume for US railroads reached 33.3 billion ton-miles, up 4.7 percent from the same week in 2004.
04/22/05 Earnings for Suezmax tankers in November reached a record of more than US$150,000 a day as global oil consumption grew faster than ship supply.
04/13/05 Overall trucking freight volumes fell 2.4% on a seasonally adjusted basis to 115.5 in February, according to an updated American Trucking Associations index released Tuesday.
04/08/05 Shipping instry faces shortages The problem now is that shipowners will have to wait until 2008 to get any delivered with the South Korean shipyards already full with orders
03/04/05 U.S. wholesale prices for heavy motor trucks jumped 1.6% in January, marking their largest monthly increase in more than five years, as equipment makers continued to pass along higher costs for raw materials, including steel, aluminum, wood and rubber
03/03/05 The Panama Canal is nearing full capacity and should seriously consider expansion to continue to be a major player in world trade, experts and users said.
03/02/05 India hikes rail freight to curb iron-ore exports China sourced more than 5 million tonnes of ore from India in January, a 46 percent increase on last year. India is China's second largest exporter of ore after Australia, according to official custom's figures.
ATA Truck Tonnage Index Surged to Record High in January.“January proved to be a strong month for truck tonnage” said ATA Chief Economist Bob Costello. “Growing manufacturing proction continues to be the driver of truck freight. And, we have seen big gains in heavy commodity movements, like steel, which is another reason why tonnage is growing at a solid pace.” he said.
02/24/05 From the JoC comes news that there is no let-up for West Coast ports. January began the year the way 2004 ended: with double-digit growth in containerized imports from Asia.
02/17/05 THE government of Panama has approved a new charging structure for containerships and has given the go ahead for big increases in charge, to be phased in on over three years, despite strong opposition from owners.
02/16/05 HUTCHISON Whampoa Ltd, Cosco Pacific Ltd and other operators of Hong Kong's port handled 7.8 per cent more containers in January as shipments of Chinese-made goods to US, Europe and Japan increased.
02/16/05 THE price paid for ships to be scrapped for steel rose 5 per cent to a record last week in Bangladesh, the world's largest ship-breaking market, as buyers competed for oil tankers to wreck.
02/08/05 The national average price of diesel fuel fell 0.9 cent to $1.983 a gallon, the US Department of Energy said Monday.
01/26/05 Liang Hong, an economist with Goldman Sachs in Hong Kong, said that the government had expanded the capacity of many ports by 30 percent to 60 percent within months, a task that would take years in practically any other country. China also increased electrical output 14 percent last year alone.
01/25/05 Shipping lines are expecting the trade between Asia and the US to register double-digit growth after a bumper 2004.
Ⅲ 彭博 怎么提取国外股市整体 PE数据
我恰好看到算你运气好
用 API，你在股票那里打 比如 aapl us equity ，然后flds, 里面搜索pe 或者 price earning, 里面会有彭博的api， 你提出来就可以了。
或者你打help, 然后问彭博的help desk
比如我要找一个股票某个时间过去12个月的PE, 应该是 =BDH(代码,"TRAIL_12M_EPS","ed-1cd",date,"Points=1","Dts=H")
如果需要详细的 你可以私信我加我QQ
Ⅳ 急！怎样在bloomberg网站上找到一年以上的走势图
至少三年
Ⅳ 查询彭博指数历史
cusp YK <GO>
GP
cusp YK GP
其实你可以直接<help> <help>有人教你用的
或者直接打电话 212 613 2000
Ⅵ bloomberg网站数据能导出excel吗比如http://www.bloomberg.com/quote/USGGBE10:IND/chart/
看你excel什么版本，好像2000上面只能用旧版，2003以后可以用新版，2002不知道。
这个只是指Bloomberg的excel addin版本，其实看你是要做什么。
如果是用一些编程语言写model之类的，可以直接调Bloomberg的各种API，这和excel无关。
如果是做spreadsheet model，可以直接在excel里调Bloomberg的excel addin提供的各种函数，或者写VBA使用Bloomberg提供的active data control。
如果只是简单的想把Bloomberg terminal screen上面的数据拿下来，用excel addin是最简单的，就是BLP/BLPH/BDP/BDH，只需要查一下security和field都是什么，这个问online help最方便。
旧版的bloomberg调用BLP/BLSH函数，新版的调用BDP/BDH函数，可以自己定义参数随时更新数据。前者用来导入实时数据，后者导入一串历史数据。
: 摸索摸索，再不行找cover你们的bloomberg sales来教好了。
Ⅶ 如何才能看到彭博金融数据
彭博有自己的终端机，您需要通过其终端机查询数据，一般只有机构会购买。
Ⅷ 请问SLV白银ETF每天持仓的变化数据在哪里可以查到，彭博上能查到吗
搜一下多得很，数据倒是好查，其他的就不好查了。。。
Ⅸ 如何用EXCEL从Bloomberg自动获取数据
一般地说，终端上你鼠标左键点击，拖动后释放，被框选的区域会自动进入你的剪贴板（不需要Ctrl+C）。
此外，将数据导出到excel可以用Excel插件，直接在Excel的公式编辑器里调用函数即可获取数据。