Report Changes

The data reports that are viewed in a neat little viewer have been the source of pleasure and pain.  Each report requires 4 different programs in .php, java, xml, and one other that escapes me at the moment.

Screen Shot 2014-06-06 at 8.10.42 PMThese programs were written back in 2008. The writer of those programs is no longer around. What I mean by that, is simply, he is a buddhist monk, and was in New Jersey at the time. One of the most fascinating individuals I’ve ever had the pleasure of meeting. Two years ago, maybe a bit more he was transferred back to China and was no longer able to communicate.  I’ve rarely heard from him since although I’ve communicated, on occasion, with his niece.

When problems arose, I luckily found a programmer, a musician, who did programming on the side. He was very good, very prompt, and very reasonable. I emailed Matt when this problem occurred hoping he might be able to fix it.

He told me he’s not doing programming any longer (music career doing well), but would take a look when he had a chance. I haven’t as yet heard back from him. The important point here is this, another means of presenting and researching the data is a must, for any fix Matt might come up with will certainly be only till the next time one of the software programs, or servers, whatever, are updated.

One of the features I really liked and many used was the download function to a .csv file. People would download and have the data on their computer. Which brings me to the possibility of a spreadsheet, Google or Microsoft instead of the problems that have occurred.

One thought was to have four spreadsheets one for Sectors, Industry Groups, Indexes, and ETFs. Each sheet could have three tabs which would be the equivalent of 12 reports from above.  The tabs might be…

Screen Shot 2014-06-06 at 8.25.43 PMExcept the ETF spreadsheet which does not contain composite data. I’ve set one up for ETFs.

Screen Shot 2014-06-06 at 8.34.53 PM

Here’s a link to a SAMPLE ETF REPORT SPREADSHEET.  Look it over, play with it, Copy it down to your computer, Excel or other spreadsheet program. Then give any suggestions you might have  😉

Another option is to use Microsoft Excel and let you download that spreadsheet to your computer.  A few potential problems here: I hope to have links moving down from Sector, to Industry Groups, to the stocks contained within. Will they work if you download an Excel Spreadsheet? Of course you can copy the Google spreadsheet and paste it into your excel.

As you can see in the picture above the Google spreadsheet was having a problem downloading prices. Might be because it’s such a big sheet. Let’s see if it eventually loads.

I could have most of these four spreadsheet ready this week sometime. The biggest time consumer will be getting the links in the spreadsheet. Let’s see how it plays out this week.


Talking Points and Should Investors Be More Excited About Dow 17,000?: 

Bond Rally Is Squeezing the Trading at Big Banks (DealBook)
The ECB and the Hesitant Eurozone Recovery (Cumberland)
The Taming of the Trading Monster (or, the fund formerly known as SAC) (NY Mag)
Bulls Are Winning The Battle Of Indecisiveness (Short Takes)
The Job Market’s Five-Year Recovery in 10 Charts (FiveThirtyEight)
Mission Accomplished (Market Anthropology)
Get Over Your Fear of Conflict (HBR)
Revealed: The world’s cheapest stock markets (Telegraph)
Zweig: Exploring Alternative Investments (WSJ)
Get Out of Stocks!* (Investing Caffeine)
Portfolio Tracking Is For Losers (Psy-fi)
Not even a bull market can interest people in stocks (MarketWatch)
Geithner’s Dubious Accounting (Bloomberg View)
The Robots Running This Way (MIT Technology Review)
Does Academic Research Kill Returns? (Morningstar)
Lawrence Summers on ‘House of Debt’ (FT)
Jimmy Iovine: The Man With the Magic Ears (Rolling Stone)
65 Things We Know About NSA Surveillance We Didn’t Know a Year Ago (Gizmodo
If everyone’s an idiot, guess who’s the jerk?  (Aeon)
More Scrutiny, Still Spectacular (NYT)

Should Investors Be More Excited About Dow 17,000?

HAVE A GREAT DAY!