Observations, Calculations, and Values
As I wrote about a month and a half ago, it’s news to just about nobody that the central banks of the world are expanding their balance sheets. But the scale of the Fed’s expansion left my eyes popped.
The below chart shows total Federal Reserve credit, which now stands at over $2 trillion, [...]
Part of the reason that I started this site was to publish some of the basic techniques and examples that I’ve developed over the year for working with data in spreadsheets. One prime example is interpolation. Excel gives you a =TREND function, and an =FORECAST function, but those run regressions, which is helpful [...]
Here’s a quick and easy way to get stock market quotes from Google, Yahoo, and Yahoo Japan into a spreadsheet. You just type=gq(”IBM”) for example, and the function goes out to google finance and pulls down the most recent quote.
Here are the functions are in the file:
Google
Name: =gname(”IBM”) returns the name of [...]