Thursday, March 29, 2012

International Financial Statistics Has New Interface

International Financial Statistics has a new, user-friendly interface.

This is where you go to find data on interest rates, financial reserves, money, deposits, GDP, prices, employment, production numbers and trade (and more).

Data is available for most countries of the world.

BTW, I like the different kinds of interest rates available: money market, discount, lending, desposit, and short or long government bonds (for most countries).

IMO, the best search method:

Go to Query Builder
Select Concept (tip: Interest Rates Hidden Under Financial Indicators)
Change the Time Period to Include Multiple Years (if needed)
Select Countries

FYI, sometimes historical data for certain concepts and countries is not available.

Monday, March 26, 2012

Books on Contracts

Do you know how to analyze a contract? How to look for hidden problems, implications, or how future events might effect that contract?

A good place to begin here with this recommended review of contracts!

Or

Main contract books.

List of related contract subjects here.

Friday, March 23, 2012

Historic Currency and Commodity Prices in Online New York Times Archives

You can get historic currency exchange rates, bond and interest rates, plus commodity prices, in old editions of our online New York Times.

Limit your search by date, and do a keyword search like price of gold, currency exchange, or similar words. There should be a brief article listing the prices.

A link to the New York Times archive from 1851 to 2007

Hat Tip: Rory Elliott

Tuesday, March 20, 2012

Book Review: The Other Path by Hernando de Soto

In The Other Path, Hernando de Soto makes the populist argument for capitalism and property rights in the 3rd world.

The social and economic environment of many 3rd world nations resembles feudalism, with entrenched economic privileges and near-overt ethnic discrimination. The privileges of the elite are protected by law, which creates economic stagnation for the poor - if they follow the law, which, out of the need for survival, they don't!

So, an informal economy springs up, with noisy microbuses and illegal markets. For the majority of the people, this is where market clearing prices exist. People live as squatters, oftentimes in rather nice houses.

Trouble is, you are outside the law and you do not have formal title to property or legal protection.

De Soto argues that the fait accompli of these markets and businesses should be recognized formally and given protection of the law. This action unlocks capital (via loans), reduces crime, and brings people psychologically into the community.

At the time, Peru was fighting a Maoist insurgency in The Shining Path (hence the title of this book), but De Soto's work stands as an interesting contribution toward our understanding of the black market.

Friday, March 16, 2012

What Investors Can Learn From Accounting Standards

Here's a way to get a little more insight when looking at a company's financials.

One size of analysis does not fit all - and contracts, depreciation, costs, inventory and other financials may be handled very differently owing to the reality of the industry.

Retail, housing, airplane manufacturing, cosmetics and more all experience these metrics differently.

1. Go to Checkpoint.


2. Make sure the drop down box is tuned to accounting, audit and corporation finance.

3. Set Tab to Search

4. Look to the right - you'll see AICPA Audit and Accounting Guides



It's a great way to see what analysts are seeing when they upgrade or downgrade a company!

Tuesday, March 13, 2012

Robots Writing Some Financial News Articles

Presented to better inform you about the nature of information out there in the world today.

Yes, artificial intelligence has progressed to the point that increasingly, news providers are creating content written by, for lack of a better word, robots.

Unfortunately, the world is not purely logical with fixed rules and completely knowable data sets and this is what robot written stories are going to miss.

Just like us turbo chimpanzees, you can also mess with robot minds.

By the way, check out this article about mechanical cockroaches influencing the behavior of other organic cockroaches. Don't be fooled!

Thursday, March 8, 2012

Word Proximity Search in Databases

Ever wish you could do even more precise word searches than AND, OR, NOT in a database?

There are advanced and algebraic (more on that in a second) search features hidden in most databases.

First up: proximity searching. These searches allow you to search two words within a certain occurrence of each other.

Let's quote Ebscohost:

The proximity operators are composed of a letter (N or W) and a number (to specify the number of words). The proximity operator is placed between the words that are to be searched, as follows:

Near Operator (N) - N5 finds the words if they are within five words of one another regardless of the order in which they appear.

For example, type tax N5 reform to find results that would match tax reform as well as reform of income tax.

Within Operator (W) - In the following example, W8 finds the words if they are within eight words of one another and in the order in which you entered them.

For example, type tax W8 reform to find results that would match tax reform but would not match reform of income tax.

In addition, multiple terms can be used on either side of the operator. See the following examples:

  • (baseball or football or basketball) N5 (teams or players)
  • oil W3 (disaster OR clean-up OR contamination)

OK, see the algebra-like parantheses above?

It also works for searches like (Argentina or Brazil) and (inflation or devaluation) so you can search several words for each slot and still keep your intentions together.

Always click the help function of each database to see exactly how to use their special commands.

Friday, March 2, 2012

Exploring A Stock Index (FTSE 250, Russell 3000, etc.)

Standard question: run a specific query on a stock index (Russell 3000/S&P 500, etc...)

1. Go to Mergent and choose advanced search
2. Select Index on the far right
3. Add as many other parameters as you want (profits, sales, other financials)

Get results from that index that meet that criteria.

Or you could generate a list for 1 or 2 attributes for all of the companies on the index.