Brad Lucas

Programming, Clojure and other interests

Installing The Solidity Plugin Into Webstorm And PyCharm

August 5, 2017

The following instructions work for other JetBrains environments. Here I only added the Solidity plugin to WebStorm and PyCharm.

The latest version of the Solidity plugin is available here:


Continue reading →


August 4, 2017

I found an interesting tool which I've been using to show current cryptocurrency values. It is called Cryptop. It is a Python app which shows current values for a cryptocurrency portfolio.

See it's git repo for the detail on how to install and run.

If you want the green screen shown in the instructions edit the config.ini in .crypto directory which is created after you first run the app. Change the default values to the following.

Continue reading →

Get Hyperlink Value From An Excel Cell

August 3, 2017

I received a spreadsheet with a list of addresses setup so you can click the name in the cell and it would open. I wanted to export the actual url which is inside the cell.

You can do this with a function. Open the VBA editor with Fn/Option F11 on the Mac. Then Open Modules and insert a new module with a name of your choosing.

Paste in the following function, save and exit the VBA editor

Function GetCellURL(cell As Range) As String
     On Error Resume Next
     GetCellURL = cell.Hyperlinks(1).Address
End Function
Continue reading →

Default ssh usernames for ec2 instances

August 2, 2017

I started a project with many different ec2 instance types and found the following link very useful recently.

Continue reading →

Cleaning Global Installs With Pip

August 1, 2017

I moved to Python3 and looked back and realized I had a ton of things installed globally for Python2. With this realization I wanted to clean everything out.

Here is one method

$ pip freeze > requirements.txt
$ pip uninstall -y -r requirements.txt
Continue reading →