How to Get Real-time Bitcoin Price in Excel

If you hold crypto-currencies like BitCoin, LiteCoin, Ethereum and would like to track the value in real-time on an Excel spreadsheet then this is the easiest way to do so!

If you want to get started with Bitcoin you can open an account at CoinBase.

I have created a spreadsheet with an embedded plugin designed to update Bitcoin and other currencies automatically and populated it with some data to spur your imagination.

Step1 –  Download this zip file which contains and Excel 2016 spreadsheet:

Crypto Bitcoin Holdings Value


Step 2 – Extract the Excel Spreadsheet “Crypto Bitcoin Holdings Value” and save it to your PC

Step 3 – Save the zip file that is embedded in the spreadsheet to your PC, or double click on the zip that is embedded and extract the file that way. Your Choice.




Step 4 – Close Excel, and Extract the plug-in from the file, save it to your PC

Step 5- Run the plug-in. After installing it Excel will have a new tab called “Crypto Excel”





Now you are set up and ready to modify the spreadsheet however you like to fit your unique scenario. When you open the spreadsheet you’ll see that I have pre-populated 3 Cryptocurrencies; BitCoin, LiteCoin and Ethereum with a theoretical situation.  The logic behind the layout is:

  • Master OverView – Current state of your currencies. Some may be waiting to be funded, you may have multiple wallets – adjust to your situation.
  • Available Funds – Money readily available for purchases or trade, probably sitting on an exchange.
  • Hard Wallet – Money in a hard wallet like Trezor or in a paper wallet. Offline and secure from breaches.

You’ll notice that there are several #N/A fields wherever a coin price should be – go to the CryptoExcel tab and click CONNECT.





Ta-Da! Real-time bitcoin prices in an Excel spreadsheet!

You can add other currencies listed on the CURRENCIES tab using the formula =CC_RATE(“LTC”, “Coinbase”) – just replace LTC with the symbol of the currency you want to track!

Also take a look at the yellow highlighted fields – change to fit your numbers.

Happy Cryptoing!
Donate BTC to me? Sure you can! Thanks for asking! 115vhqSUbHrxAEiF65SuZzCUSQBtknqEAi

How To Change Default Roku Unit Name for Mirroring Mode

So you have your new Roku device set up and want to mirror your PC, Phone or Tablet to the unit.  There are hundreds of tutorials on how to do that.

What is less obvious is how to change the default name that comes up when you are making the connection.  Instead of “Roku Device – 166”, I wanted to change mine to “Curran TV”. Because . . . Aesthetics.

If you haven’t created an account at, you’ll need to do that first. (Odds are, you already have.)

On your computer:

  • Go to
  • Select My Account
  • Scroll Down to My linked devices
  • Chose the device you want and select Rename

On your device go to:


This will Reboot your TV or other Roku unit.

When the unit reboots it will broadcast the new name you chose. This is especially useful if you have multiple TVs (Restaurant, Night Club, Big House, Hoarding Issues, Etc.)

As a side note, I think this is turned on by default but just in case it isn’t, check:



Microsoft Lumia 950 Crashes, Reboots and Locks Up (SOLVED!)

Lumia 950 Crashes when taking a picture? Lumia 950 Crashes when a call comes in? Lumia 950 has to be soft-reset constantly? Lumia 950 audio glitches out and repeats like Max Headroom stuck in a loop?

Have you taken it to the Microsoft store and had them reflash it and run diagnostics to no avail?

Have you read online forums and posted to the Microsoft Feedback Hub it vain?

My wife and I both have Microsoft Lumia 950 phones we purchased the same day just over a year ago. Mine started glitching out. Crashing, rebooting, generally making me want to chuck it against a wall.


Finally figured it out. Why is mine acting up and not hers? Answer: I use mine more.

And if I use mine more . . . there are more cycles on the battery.

Replace the battery.

It’s that simple.


***Author’s Note: I’ll be posting the link to this solution in various forums. Please help spread the word. I love my Lumia 950 and damn that was frustrating!

How To Automatically and Anonymously Download Your Favorite TV Shows

Lets say you were going to get rid of your television but still wanted to be able to watch your favorite shows at your leisure.  No problem. Here’s how:

This is not going to be a tutorial on the magic of Bit-Torrent, Wikipedia does a fine job at that:

BitTorrent is a peer-to-peer file sharing protocol used for distributing large amounts of data. BitTorrent is one of the most common protocols for transferring large files, and it has been estimated that it accounts for approximately 27-55% of all Internet traffic (depending on geographical location) as of February 2009.

BitTorrent protocol allows users to distribute large amounts of data without putting the level of strain on their computers that would be needed for standard Internet hosting…. The protocol works as an alternative data distribution method that makes even small computers with low bandwidth capable of participating in large data transfers.

There are several bit torrent programs available but in the spirit of keeping things extremely simple we are going to use a pre-configured version of uTorrent. We are also going to use an anonymizer service that will cost about $7.00 a month.  I stand by it whole-heartedly and believe it is worth the 7 bucks a month to remain anonymous. If you don’t feel the need to use it  – skip ahead to right here: Click Me.

First, Go to and create an account. I have a subscription. If you just want to “test the water” make a single month payment.


Once your account has been created click on the link that reads Install BTGuard

Choose the Easy Install

Recommended for most users, the easy method will install a pre-configured BitTorrent client (uTorrent) & encryption software. All you need to do is download and install!

For windows only, please use the advanced install of Vuze for Mac or Linux.

Once you have downloaded the BTGuard file, run it to install the pre-configured version of uTorrent


You will be prompted for your BTGuard login information, fill it in and select ok.:


The software will check your account status and then give you a message stating all’s well!


Select Continue and  – whats this?


If you get a similar firewall message make sure you tell the program to ALLOW uTorrent. In this case I will choose Unblock.

Would you like to make uTorrent the default torrent application? Yes indeed and “Always perform this check!”


Ta-Da! You have a Bit Torrent program installed!

Let’s look at 2 settings  – Click on the yellow gear icon or select OPTIONS –> PREFERENCES and go to CONNECTION

You will see that the information for a proxy server has been filled in automatically:


The other setting to take a look at is DIRECTORIES. I don’t think i need to give you a screen shot for that one – just select what folder you want your downloaded files put into. I have a folder in My Documents I created called Recently Downloaded. Whatever works for you – make it so!

At this point we have the ability to download movies and television shows using uTorrent. Now let’s set up which ones we want . .

Go to showRSS and register for a new account. You don’t even need to supply an email address!


Don’t forget your username and password. You will need it to add and remove programs later!

Once you have created the account the next step is to create a list of television programs you want to subscribe to. I’ll add 3 to mine:


I added Californication, Caprica and Dexter. You can add all the programs you want.

Finished? Ok, now click on FEEDS

Next to Get Your Feed Address choose BOTH TYPES OF TORRENTS and INCLUDE PROPER AND REPACKS then click GENERATE.

You will be taken to a page like this:


Copy the link that looks like this:

Here comes the magic . . . Open uTorrent, select FILE then ADD RSS FEED

Paste the link address in the FEED URL Box.

Check CUSTOM ALIAS and make up a name like TV SHOWS


and check the box for USE SMART EPISODE FILTER


Click OK and hold on to your hat:


Things to remember:

1) BTGuard is costing you $7.00 a month to provide you an anonymous Bit Torrent connection.

2) uTorrent is the program you are using to download “Torrent Files” of your choosing.

3) ShowRSS is where you are managing what TV shows are automatically downloaded with uTorrent.

4) Log in to ShowRSS to add or remove programs.

5) If uTorrent is running, its checking for new episodes!

And now that you have a Bit Torrent program . . .go find some torrents!

All I ask for in return is Beer and Books. Beer and Books.


How to Forward or eMail a Webpage URL in Google Chrome

Are you looking for the magic button in Google Chrome that will allow you to send the webpage you are looking at to a friend?

There isn’t one.

So lets make it in a few quick, simple, steps!

1) Open Chrome and Right Click on any bookmark you have across the top of your browser.

2) Click on Add Page

eMail Link

For URL:

3) Save it!

Now when you need to share the latest Geek Fill posting or awesome Craft Beer discovery – just click “eMail Link!”

SOLVED: How To Fix A WordPress Captcha Text Font Error

Getting a Warning: imagettftext() [function.imagettftext]: Could not read font error message? Let’s fix it!

If you have a form on a your WordPress website and are trying to prevent spammers  from flooding your site with deals on  – well, you know the kinds of deals they promote, get yourself a “Completely Automated Public Turing Test To Tell Computers and Humans Apart” or a CAPTCHA.  You are undoubtedly familiar with CAPTCHA codes. They look like this:

Personally I’m a big fan of MM Forms so I’ll use that plug-in as my example but the theory is the same no matter what you use.

Easy enough to set-up: download it and FTP into your WordPress PLUGINS directory just like you have done for other plugins. I’ll use Filezilla in my examples. Its a great, FREE FTP program.

But do you do if you load your webpage and you get the dreaded “Warning: imagettftext() [function.imagettftext]: Could not read font…error message? Well you could Google it – but the results are uglyyyyyy. Hopefully I can save you some gray hairs. Here we go:

The directions for MM Forms read:

  1. Upload whole mm-forms-community folder to the /wp-content/plugins/ directory
  2. Activate the plugin through the ‘Plugins’ menu in WordPress
  3. Make following directories writable (chmod 777) /exports/ and /captcha/tmp /upload

Ok Wait . . CHMOD???

Its simple: “The chmod command (abbreviated from change mode) is a Unix command that lets a programmer tell the system how much (or little) access it should permit to a file. It changes the file system modes of files and directories.” Basically, you don’t want people visiting your website to just drill into any folder on your server and be able to run commands, upload files etc.

  1. FTP into your website
  2. Go to the folder you need to change (or check) permissions on.
  3. Right Click on it.
  4. In Filezilla the command to select is “FILE PERMISSIONS” – If you are using a different FTP program look for similar message.

And Ta-Da! Changing from the default of 755 to 777 is as easy as checking two boxes!


OK Done! Everything works, right? Oh wait a minute . ..  you load the webpage and get Warning: imagettftext() [function.imagettftext]: Could not read font in . . . error?

Usually this is caused by the permissions being wrong, the font files not being uploaded all the way or the font files being corrupted. Not OK. Let’s fix it!

Try this . .

  1. Find the folder inside the the plugin you are setting up what has the actual font files in it. In our case, its in wp-content/plugins/mm-forms/captcha/gentium
  2. Delete the .TTF and .VFB files. You’ll notice they are quite large compared to the other files in that directory:

And now for Trick #1.

99.9% of the time your FTP program is set to automatically decide how to transfer the files from your computer to the the server. 99.9% of the time you never have to change this setting. Welcome to the .1% of the time when you do.


Don’t worry about why for, or who what – Just select BINARY.

Trick #2 – upload the TTF and VFB files one at a time. Trust me.

Upload one, wait for it to finish (it will take longer than normal) and then check the filesize to make sure the whole file got to the server.

I repeat: check the filesize to make sure the whole file got to the server.

Repeat for your remaining files.

Cross your fingers.

Reload your webpage.

Sigh in relief. The dreaded Warning: imagettftext() [function.imagettftext]: Could not read font in . . . beast is no more!

And don’t forget to change your transfer mode back to AUTOMATIC!

Problem solved? All I ask for is Beer and Books. Beer and Books. (Kindle versions preferred)


How To Make Google Calendar Sync Work With Microsoft Outlook 2010

If you use Google Calendar sync and have upgraded to Microsoft Office 2010 you’ve no doubt discovered that the two don’t work together. Here’s the world’s easiest fix:

  1. Download this file:
  2. Unzip it
  3. Go to C:\Program Files\Google\Google Calendar Sync
  4. Rename GoogleCalendarSync.exe to OLDGoogleCalendarSync.exe
  5. Move the new GoogleCalendarSync file to this folder.
  6. Launch  Goggle Calendar Sync.exe
  7. Fixed.

In the simplest of terms, the latest version of the Sync.exe file reads the version of Microsoft Outlook differently from the way the older version of the same file does. We are simply replacing the latest version of the file with a slightly older one.


UPDATE 17Aug: Google has released an update that should work with the 32 bit version of Outlook 2010