Methodology for Bitcoin Valuation as a Fiat Hedge
• John Vandivier
This article goes over my methodology for a bitcoin valuation which resulted in my guest article on the Mineforman website here.
The spreadsheet I used, complete with all my little self-notes and summaries, is available in its original Gnumeric format here, and in the more common Excel format here. Simple Excel conversion resulted in some errors on that version. I recommend Gnumeric for all spreadsheet and basic statistical work.
Google Trends information was used to determine the rate of information spread by looking at search rates relative to a \"common knowledge\" standard rate. \"Business\" was chosen as the objective standard search term because it was 10th most popular keyword over a long time frame. All search data was analyzed from January 2011, when bitcoin searches were notable by google, until May 2013, using data from the first of each month. See the following graphical visualization:
The average interest level for \"business\" was 89 on this chart. The peak measured data point for bitcoin was 11 which occurred over the interval including April 1, 2013. When we eliminate \"business\" from the chart we are given richer data on bitcoin searches. See the following:
