Category Archives: Finance and Investments

Getting Yahoo! Finance data into Excel

Here’s a little VBA snippet that allows to retrieve Yahoo! Finance data into an Excel spreadsheet. Usage: =yfQuote(ticker, date, field), where ticker (required) is ticker symbol used by Yahoo! Finance. Examples: MSFT, ^GSPC, VXX. date (optional) is the date for which quotes … Continue reading

Posted in Finance and Investments, Technology | Leave a comment

Private equity + foreclosure = 8%

Private Equity’s Foreclosures for Rentals Net 8% By Edward Robinson – Mar 13, 2012 Bloomberg Markets Magazine Ken Major climbs the steps of a county courthouse in a San Francisco suburb with $500,000 in cashier’s checks in one hand and a list of addresses … Continue reading

Posted in Finance and Investments | 1 Comment

Institutional Investor on high-frequency trading

From Institutional Investor: Inside the Machine: A Journey into the World of High-Frequency Trading 10 Jun 2010 Michael Peltz An editor’s journey into the world of high-speed trading and proprietary algorithms that make or break markets. At 2:45p.m. on Thursday, … Continue reading

Posted in Business, Finance and Investments, Technology | Leave a comment

Smart Grid in China

From Institutional Investor: Investors Want to Plug Into China’s Smart-Grid Market 01 Apr 2010 Xiang Ji Beijing’s massive conversion to a smart power grid could just one-up the rest of the world. Savvy entrepreneurs and investors are looking to get … Continue reading

Posted in Business, Clippings, Finance and Investments, Technology | Leave a comment

Caymans sign another TIEA

From International Tax Review: Cayman Islands agrees to tax information exchange with Netherlands The Cayman Islands signed a tax information exchange agreement (TIEA) with the Netherlands on July 8. This brings the number of TIEAs signed by the Cayman Islands … Continue reading

Posted in Finance and Investments | Leave a comment

Corporate bonds boom in China

From Business Week: In China, a Burst of Corporate Bonds Thanks to streamlined regulations, more companies are issuing debt cheaply and fast By Frederik Balfour Hong Kong – Here’s a little-known fact: Chinese companies now issue more corporate debt than … Continue reading

Posted in Business, Finance and Investments | Leave a comment

B of A recaps at market

From Institutional Investor: At the Market Deal for Bank of America 03 Jun 2009 Steve Rosenbush BofA issues stock to withstand market volatility. Raising $33.9 billion in capital is no mean feat for a bank, especially given the violent mood … Continue reading

Posted in Business, Finance and Investments | Leave a comment

Public sector pension plan problems

From Institutional Investor: The Big Public Pension Squeeze 10 Jun 2009 Steven Brull U.S. public sector pensions are facing massive budget shortfalls. Vallejo, a working-class community of 120,000 northeast of San Francisco, has long been a strong union town. Like … Continue reading

Posted in Economics, Finance and Investments | 1 Comment

Bonds for Microsoft

From Business Week: Bonds for Microsoft Cash is king these days—so much so that even debt haters are willing to take out loans to get more of it. On May 12, Microsoft sold bonds for the first time in its … Continue reading

Posted in Business, Finance and Investments | Leave a comment

A dispatch from Turkey

From Institutional Investor: Turkey’s Military Pension Fund Reaps Windfall Jonathan Kandell 08 Jan 2009 Despite tensions between Turkey’s generals and the moderate Islamic government, OYAK, the military pension fund, has made the most of the country’s pro-business policies. For emerging-markets … Continue reading

Posted in Clippings, Finance and Investments | Leave a comment