Brad Lucas

Programming, Clojure and other interests


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 →

Get Ip Address Of Ec2 Instance

July 31, 2017

A quick command to figure out what your IP address is.

$ curl

Continue reading →