Saturday, June 14, 2008
Coin Tosses and Stock Price Charts
Prior to the 1960’s, most investors believed that future securities prices could be predicted (and that great riches were to be had) if only they could discover the secret. Many investors still believe this today, despite much evidence that suggests that they would be best served by simply owning the entire market (investing in index funds) rather than trying to pick individual stocks.
The efficient markets hypothesis (EMH) essentially states that techniques such as fundamental and technical analysis cannot be used to consistently earn excess profits in the long run. The EMH began with
Comments (2) • Permalink • Tell-a-Friend
Thursday, March 27, 2008
Modifying the Ribbon in Excel 2007
I have recently found a need to modify the Ribbon interface in Excel 2007. I thought it would be much harder than it actually is. Rather than going through a tutorial of my own, I thought that I would post some excellent Ribbon modification tools and tutorials.
Before doing this, you need to understand that Office 2007 files are really just archives (.zip files) of several XML files. So, if you want to explore the file you can just change the file extension to .zip and then extract the files from the archive. Windows Explorer can do this. Open Windows Explorer, find your file, change the
Comments (2) • Permalink • Tell-a-Friend
Sunday, March 16, 2008
Analyze Google AdSense Data Using Pivot Tables
Webmasters who use Google’s AdSense service to place ads on their site know that the analytical tools that AdSense supplies are pretty weak. Fortunately, it is easy to get report data from the site and into Excel where we can use all of the analytical tools that Excel provides. The purpose of this post is to demonstrate how webmasters can use PivotTables to analyze AdSense data. There are many reports that you can create in AdSense, and they are all candidates for analysis within Excel, but I will be demonstrating how to use pivot tables to analyze the "This month, by day" report that is
Comments (1) • Permalink • Tell-a-Friend
Sunday, February 03, 2008
Charting Economic Time Series with Shaded Recessions
If you read the business press or government economic reports, then you have undoubtedly seen charts that show recessionary periods with shading. In this post I will demonstrate how to create this type of chart in Excel 2007. The same technique is applicable to all versions of Excel, though the mechanics of creating the charts in earlier versions are slightly different. Users of other spreadsheets, such as Open Office Calc should be able to use a similar procedure.
Obviously, if we are to chart an economic data series and shade the recessions then we need data. For this post I will be
Comments (5) • Permalink • Tell-a-Friend
Wednesday, January 16, 2008
Native Excel 2007 Viewer Now Available
Microsoft released a new version of the Excel Viewer program on 14 January 2008. This version natively (without conversion) supports the viewing and printing of Excel 2007 files as well as all previous Excel files back to Excel 97. Here is the description from the site:
With Excel Viewer, you can open, view, and print Excel workbooks, even if you don’t have Excel installed. You can also copy data from Excel Viewer to another program. However, you cannot edit data, save a workbook, or create a new workbook. This download is a replacement for Excel Viewer 97 and all previous Excel Viewer
Comments (0) • Trackbacks (0) • Permalink • Tell-a-Friend
