What I’m Doing: I have the rest of the week off of work and am focusing on improving my python. I figured out how to connect to my Microsoft SQL Server using pyodb. Here is the easy to remember connection string using set variables:
cnxn = pyodbc.connect('DRIVER={ODBC Driver 17 for SQL Server};SERVER='+server+';DATABASE='+database+';UID='+username+';PWD='+ password)
From there, I have been using pandas and matplotlib to graph some of the financial data I store in my “Project Edge” database. I am practicing elements of feature engineering to see if I can get more insight from my data using machine learning in the future.
What I’m Lifting: As a Christmas gift to myself, I bought a 15lb kettle-bell and have been swinging that around a little bit. I want to get back into the gym, but I’ll tackle switching my hours and getting back to school first. In the meantime, I enjoy using it to work out and wish I would have gotten one sooner.
What I’m Eating: We made some fajita seasoning using some spices and herbs we had sitting around, and then cooked up a big batch of chicken and peppers. It was delicious! Much better than the store bought seasoning we used last time. Unfortunately, no margaritas since we’ve been out of tequila for months.
What I’m Thinking about: I can’t wait for warm weather. The past couple days have been the coldest days of the year coming in at -35f. Rigby couldn’t even last outside for more than thirty seconds!
What I’m Studying: I’ve been trying to add more elements of technical analysis to my financial data database, so I’ve been researching how to write things like sma, ema, Bollinger bands, RSI, etc… Some of them are much more difficult to write in SQL than I would have imagined! It has been some fun problem solving.
Eric Kleppen Wins 