Krehn Solutions Blog

The personal blog of Raymond Krehn

Category: Dreams

  • Peer-to-peer Lending Evolved

    My article relating to Peer-to-Peer Lending is one of my most popular articles with over 6,000 visits. I think that’s a rather huge accomplishment for a personal website with no desire to publically broadcast. One of the items I talk about later in the article is how to reduce risk while increasing rewards. Using backtracked data that spans billions of dollars, I decided to test out a few algorithms that could potentially maximize my return interest.

    After testing these algorithms for over a year, I was astonished at the results. I’ll share these in a moment. I thought to myself, “what if I can share this with the world?” It was a unique challenge for me. I knew that Lending Club offered API, as I discussed in the aforementioned article. What I wanted to know was whether or not it was possible to interact with other people’s accounts and share the same algorithm using that same API. It was. While challenging at times, I believe my efforts were worth it.

    Today, I introduce to you Flux Robot. You can see the results at the bottom of the page or in the performance section.

    Update: This site has since been closed since Lending Club no longer offers peer-to-peer lending. You can find the page and a working version under my portfolio.

  • Reading Lines in C#

    I came across an interesting scenario today while I was building an application that required me opening a file, reading it line by line, and importing it into a dataset. The reason this was an interesting scenario is because there is data that belongs to a specific identifier on different lines.

    (more…)

  • SQL Basic Maintenance Script

    I came across a database that has suffered a lot of deadlocks recently. This, along with slow query execution among other problems led me to convince management that the database required downtime. Some of the maintenance I performed was re-building tempdb tables and moving them off the C Drive, which I highly recommend for various reasons. You can read more on that here.

    (more…)

  • Cutting Television

    I’ve had a television service ever since I was a little kid. I remember when I had an antenna on top of my box that we called “bunny ears.” Yes, the television was a large box with ears. We had to adjust the antenna once in a while to get clear reception, or the channels would get some fuzz or be gone completely with white noise. The problem was that some of the channels would be clear and others would not. If I wanted to see another channel, I would go up to the television and change the channel by a knob. I may have had to adjust the antenna again to get a picture. We knew something was on a channel at a certain time through TV Guide. It’s still around today, but it’s all digital. It was similar to a magazine, and it had ads throughout so you knew what the latest and greatest shows were.

    (more…)

  • Adblocking

    Note: Recommendations are at the bottom if you want to skip this article.

    I came across an easily one-sided article that states in the opening statement, “The use of ad-blocking software is exploding and is projected to cost websites nearly $22 billion in lost advertising revenue worldwide this year, according to a new study.” Without going into semantics about the definition of cost, what this article should really state is that ad-blocking software projects to reduce potential revenue by $22 billion worldwide this year. The key difference here is the costs haven’t incurred yet and it’s only potential income.

    (more…)

  • My SSD is near capacity. What can I do?

    I see this question a lot and it actually bothered me that my 120 GB Solid State Drive (SSD) was near full capacity despite the fact I install almost everything on a secondary drive. I try to keep only my Windows installation on the SSD for incredibly fast boot times. If you’re unfamiliar with the SSD, here’s a simple comparison with the same computer by ASUS:

    (more…)