"But you're so positive you know all the lore of the forest. It's difficult. Have you counted the trees?"Its possible to find out what a shipping company earns before they announce their earnings.
"How count the trees?" said Stepan Arkadyevitch, laughing, still trying to draw his friend out of his ill-temper. "Count the sands of the sea, number the stars. Some higher power might do it."
"Oh, well, the higher power of Ryabinin can. Not a single merchant ever buys a forest without counting the trees, unless they get it given them for nothing, as you're doing now. I know your forest."
Shipping fixture details are made available on a subscription basis through the Baltic Exchange, the same folks who produce the BDI, and for free at 2 shipbrokers: platou and skaarup. Since the Baltic data costs 3+ grand (per annum) if you deal with them directly, and the shipbrokers seem to make the same data available for free, we'll go with them.
how to
1) get a copy of the fleet list (looks like this)
2) match each ship to a fixture on platou or skaarup (looks like this)
note: platou has historical data going back several months, and so is a good place to get started.3) parse this into a spreadsheet (columns for charterer, ship name, rate, date, dead weight)
of course *some* ships may be out under contracts that predate the data, and so will remain a mystery.
note: the date stamp is particularly wonky in this data: example "10-12/8.2008"4) subtract fixed costs to taste (daily operating expenses, debt service, etc)
this seems to be the start date of the fixture w/ a few days of padding ^^^^
(ie they take the ship around August 10th-12th)
5) compare results to quarterly earnings. redo step 4 to calibrate.
Now this is all a *enourmous* pain in the ass to do by hand and crazy sexy when done with a program. The data fetching can be done via screen scraping (choosy roustabouts like Beautiful Soup) and then chucked out into CSV or XML. Fleet list data for a slew of different shipping companies can be kept current in a similar fashion - either in a plaintext conf file or in a db table - all the public firms have their ship details online. Operating costs (ie 8k/day for a panamax), debt service, etc can be kept as constants or one-off values. AND all of this can be setup to run from a cron job once or twice a day.
The result of all this sexiness?
A daily report that keeps one up-to-date on projected cash flow and EBITDA before earnings announcements. This so fucking works and means you don't have to wait around for some higher power to count all the trees and tell you the number.
the proper use of a tree counter
While it might be possible to do all this with the accuracy of the firm's CFO and try to be all predictive with earnings and buy/sell around quarterly announcements, this is ultimately a foolish and very tedious game.
The proper use of a tree counter is all about the dividend.
The tracking of fixtures offers a sanity check of the dividend. That is, it can be an early warning system to see if the dividend is at risk and a way to determine its long term viability.
Most shippers who offer high-dividend yields are weighted to long term contracts rather than spot voyages; a properly calibrated tree counter can reveal the ones w/ the best rates, which ones have the most potential to increase their dividend, and permit you to check your investment with a proper degree of diligence (and sexiness) and a minimum amount of time.
Scrooge McDuck from an old episode of DuckTales, the animated cartoon:
"work smarter, not harder"











