Author Archives: Patrick

New Website Project: Amped Cycling!

parked bicycles

One of the noticeable trends I’ve noticed in the past few years, particularly in this strange, locked-down time we live in, is an uptick in cycling. Cycling is cheap, it’s healthy, and it allows us to avoid unnecessary contact with others in an enclosed train or bus. So it’s no surprise that it’s becoming more and more popular.

I’ve been cycling to work for about two years, and in that time I’ve noticed much more people getting on bikes, particularly ebikes.

Therefore, I’ve decided to launch a new project, called Amped Cycling. It’s a site that will focus on bike commuting with electric bikes, with reviews, accessories and lots of fun content. I’m really excited to share some trends that I’ve noticed- such as it’s it possible to go shopping with a child, buy the groceries for three people, all without a car? How can you manage cycling to the office, in all weather, while minimising sweating?

Come along for the ride! See you soon at Amped Cycling!


Streaming Safely and Hassle-Free – Useful Software, Tools and Tutorials

In order to use online streaming safely, and to reduce the hassle involved, I’ve compiled a list of useful resources for you.

Streaming Tip - Stay Safe and Unlock Geo-Restrictions

Acestream involves using peer-to-peer (P2P) services. Sometimes these are in a legal grey area depending on your geographic location. You should never use free VPN proxies, especially Chrome/Firefox addons.

I use NordVPN (disclosure: affiliate link, please consider using this link if you find this guide useful, thank you!) More information regarding how they keep your data private from their FAQ.

Using a VPN also allows you to stream from sites that are restricted to certain countries (geo-unblock sites like the BBC, RugbyPass and so on).

Reddit Table Formatting Helper

Do you get confused when you wish to have a nicely formatted table in a Reddit comment or a text post? This happens to me semi-frequently, so much so that I made a simple Google sheet to fix the problem once and for all.

You can find the sheet at the following link, along with instructions on how to use it. You’ll never get stuck remembering the correct formatting for a Reddit table again:

Reddit Table Formatting Helper

Rugby Live Streams – The Best Free and Premium Rugby Streaming Sites

In no particular order, here is a list of free and premium rugby streaming sites.

Rugbypass [Link]

Rugbypass is a premium rugby streaming service, offered in many Asian countries.

$7.99 weekly / $19.99 monthly / $159.99 yearly

Bangladesh, Bhutan, Brunei, Cambodia, China, East Timor, Hong Kong, India, Indonesia, Laos, Macau, Malaysia, Maldives, Myanmar, Nepal, Pakistan, Philippines, Singapore, South Korea, Sri Lanka, Taiwan, Thailand and Vietnam.

The Six Nations, The Rugby Championship, June & November Internationals, Super Rugby, European Champions Cup, Aviva Premiership, Mitre10 Cup, Currie Cup, selected matches from the Pro14 and Top14

Geo unblock - watch from anywhere

Dazn [Link]

Dazn is a relative newcomer to the world of sports streaming. It’s a legal service that broadcasts many sports, including rugby union.

€9.99 per month

Germany, Austria, Italy, USA, Switzerland, Canada and Japan.

Rugby 7s tournaments, 6 Nations, Rugby World Cup, Aviva Premiership. Updates here, regarding countries where it’s available.

Geo unblock - watch from anywhere


Streaming Tip - Stay Safe and Unlock Geo-Restrictions
You should never use free proxies, especially Chrome/Firefox addons . I use NordVPN (disclosure: affiliate link, please consider using this link if you find this guide useful, thank you!) More information regarding how they keep your data private from their FAQ. Using a VPN also allows you to stream from sites that are restricted to certain countries (geo-unblock).

BBC iPlayer [Link]



6 Nations, some international games

Geo unblock - watch from anywhere

ITV Player [Link]



6 Nations, Rugby World Cup

Geo unblock - watch from anywhere

Channel 4 [Link]



Some internationals

Geo unblock - watch from anywhere

TV Catchup [Link]



Stream BBC and ITV for free, outside the UK. Watch any game that BBC 1, BBC 2, ITV 1 or ITV 2 is broadcasting.

S4C [Link]


Welsh channel, showing Pro14

UK, perhaps more, details here. Also available on TV catchup, see above.

Premier Sports [Link]

£9.99 per month


Information on rugby union coverage here

Geo unblock

NowTV [Link]

NowTV is the official online streaming service from Sky Sports UK. They are quite expensive, recommend looking at other options before them.

£7.99 per day / £12.99 per week / £33.99 per month / 10 month Sky Sports Season Ticket for £179 (Limited time)

UK (You can also watch in Europe, according to the site)

Geo unblock - watch from anywhere

RTE Player [Link]



6 Nations, Rugby World Cup

Geo unblock - watch from anywhere

TV3 Ireland [Link]



TG4 Ireland [Link]

Irish language channel




EirSport (Ireland) [Link]

Available with broadband package/separate, additional premium package with Sky TV Ireland

Ireland, discussion here

Guinness PRO14, Champions Cup Rugby, 2019 Rugby World Cup, Gallagher Premiership Rugby

Geo unblock - watch from anywhere

World Rugby – Official Website [Link]



Tournaments: U20 Rugby World Cup, World Rugby Nations Cup, other less well-known tournaments


Streaming Tip - Stay Safe and Unlock Geo-Restrictions
You should never use free proxies, especially Chrome/Firefox addons .

I use NordVPN (disclosure: affiliate link, please consider using this link if you find this guide useful, thank you!) More information regarding how they keep your data private from their FAQ.

Using a VPN also allows you to stream from sites that are restricted to certain countries (geo-unblock).


Useful Software, Tools and Tutorials

Easiest Way to Sell Bitcoin to PayPal

guide-on-how-to-sell-bitcoin-to-paypalSell Bitcoin to PayPal? How is this possible?

This is the complete guide to selling your Bitcoin to PayPal with 15% markup and converting your Bitcoins to USD or local currency in your PayPal account.

There are other guides showing how to sell Bitcoins to PayPal, but none of them discuss how to sell at a 15% markup to the current market price of Bitcoin.

This is a great method of cashing out from:

  • Coinbase to PayPal
  • Gdax to PayPal
  • Poloniex to PayPal
  • Kraken to PayPal
  • Offline cold storage wallet to Paypal
  • Bitcoin to bank account – via PayPal

Guide Summary

  1. Go to xCoins
  2. Open an account
  3. Link your xCoins account to PayPal wallet and select your settings for buyers.
  4. Transfer your Bitcoin to your xCoins wallet
  5. Wait for your Bitcoin to be sold – 100% automated by the xCoins, and completely secure
  6. Receive USD or local currency from the Bitcoin sale into your PayPal account

You can then use the funds in your PayPal account as usual, for online purchases or cash out to your bank account.

Steps 1-3 take perhaps 15-20 minutes to complete. Steps 4 -6 are completely automated.

 1. Go to xCoins

xCoins describes itself as a secured P2P Bitcoin lending service. It’s more accurate to describe it as a place to sell Bitcoin at a markup (from the sellers’ point of view)

2. Open an account

Click “sign up” on the top right hand corner:


Fill out your name, email, agree to terms of use and confirm that you’re not a robot:


Copy and paste the email confirmation code, sent to your inbox:


Enter “3fscfw” into the promotional code box (optional):


Enter a password:


Select your country (and state, if necessary):


Enter a phone number.  This is used to confirm withdrawals for security reasons. It’s a very important feature to protect your Bitcoin balance:


3. Link your xCoins account to PayPal wallet and select your settings for buyers.

Select “Lend Bitcoin” in the main menu. Click the green plus icon:


Enter your email address that you use with your PayPal account:


You may need to verify this in your email inbox.

4. Transfer your Bitcoin to your xCoins wallet

Move your mouse cursor over “My Wallet” in the menu, and click “Deposit Bitcoin”. Copy the wallet address (long string of text):


Go to your Bitcoin wallet – you may have Bitcoin at an exchange such as Coinbase, Kraken, Poloniex or an offline wallet on a computer or USB drive. Send a small amount of Bitcoin first to the address you just copied from above, to test that everything works correctly! When the first transaction shows up in the xCoins wallet, feel free to deposit as much as you like.

Note: due to the delays currently being experienced on the Bitcoin blockchain, the deposit will likely take at least 30-40 minutes to appear in your xCoins wallet. This is nothing to do with xCoins, it affects all users of the Bitcoin blockchain. Don’t worry, it will arrive eventually.

Next, you need adjust the settings which affect what kinds of buyers can actually purchase your Bitcoin. Below is a screenshot with my settings, feel free to adjust according to your own risk appetite. Be aware that Rating refers to the number of times a buyer has used xCoins – so 1 = 1 first time buyer (higher potential for PayPal disputes or chargebacks), 2 = second time buyer (much lower risk), and so on.


Steps 5 and 6 – waiting for your Bitcoin to be sold and receiving USD or local currency from the Bitcoin sale into your PayPal account are completely automated.

That’s it! You can also use xCoins to continuously earn passive income with Bitcoin.

How to Export Passwords from Lastpass to KeeWeb or KeePass

I recently became interested in switching away from Lastpass , a password manager that is very convenient, but has some drawbacks for me, for several reasons.

My Requirements

I wanted a password manager that would allow me to:

  • use iOS as well as my desktop PC
  • Utilise an open source project
  • Control where the file containing the list of passwords was stored.

With KeeWeb, you can store locally or in cloud storage like Dropbox or google Drive.

The Challenge

Unfortunately, getting your account names, usernames and passwords out of Lastpass and into KeeWeb is a somewhat complicated process. This guide helps you through this process, step by step.

The Solution

The process involves: exporting the data from Lastpass, cleansing the data in Excel, importing the clean data into KeePass (a free windows password utility), saving the data in a format that KeeWeb recognises, and finally importing the data into KeeWeb.

Step by Step: Cleaning the exported Lastpass data and importing to KeeWeb

According to this help file [], your information must be in this format:

“Account”,”Login Name”,”Password”,”Web Site”,”Comments”

  1. Go into lastpass vault, select export, enter password. Ctrl-A, Ctrl-C and save as lastpass.txt.
  2. Open Excel. Data tab, From text, select the new text file you just created. Separate by commas, you should see the data split neatly into columns.
  3. Next step is to clean the data. Rename Sheet1 excel tab to “Original Export” and rename Sheet2 to “Clean Export”. We will use Sheet2 to create clean data that KeePass (the utility we use as an intermediate step) will recognise.
  4. Hide all columns except the “url” column
  5. In the cell next to the “url” cell, type in “Valid HTML?” (in my case, cell number H1) and enter this forumla in the cell below it: =(IF(LEFT(A2,4)=”http”,”Y”,”N”)) Drag this formula down the list of URLs, until you come to a point in the spreadsheet where none of the cells in the URL column start with “http” (this is the export of your Lastpass secure notes). With the list of cells still selected, go to the white box on the top left (to the left of the formula bar) where it states the current cell/range, double click it, and type “validTest”. This will quickly allow us to reference this range. This forumla will detect the cells where the value starts of doesn’t start with “http”. This allows us to quickly find the cells where the exported data is in a format that KeePass won’t recognise.
  6. In the cell next to “Valid Html?” type “Non valid count:” (Cell I1 in my case) and in the cell next to that, type “=COUNTIF(validTest,”N”)”. this quickly counts the number of non-valid urls from our overall list.
  7. With the list of cells still highlighted, go to Home tab> Conditional Formatting > Highlight Cell Rules > Equal To > type in “N” (with quotes) and for formatting select “Light Red Fill with Dark Red Text”. This highlights all the broken links in red for us.
  8. On the numbered left column, click row 1, to highlight all the cells. Select Data tab > Filter.
  9. In the column headed by “Valid HTML”, click the dropdown arrow and select only the “Y” checkbox, click OK.
  10. Unhide all the columns
  11. In the “Cleaned Export” sheet, name cells A1-E1 “Account”,”Login Name”,”Password”,”Web Site”,”Comments” respectively.
  12. The order of the columns is different in Lastpass to what KeePass expects. This is the order in Lastpass exported file: url, username, password, extra, name. In case it’s not clear Account=name, Login Name=username, Password=password, Web Site =url, comments=extra. Copy all the (filtered and valid) data from the original sheet to the cleaned sheet. Make sure that you don’t change the order of the rows. Make sure to sort the data into the correct column!
  13. Now Ctrl-A and Ctrl-C all the clean data in the sheet. Open notepad, paste in the text. File> Save As> “lastpass_clean1.csv”. In the file type, select all files.

To be continued…

Bitcoin Trading Bots

Large list of open source and commercial Bitcoin/Altcoin trading bots.

Open source projects



Bitcoin Arbitrage


Rolling bot

Lucky horse

Gekko | Youtube Explainer


Coinbase Orders

Hosted VersionGitHub (self hosted version)BitcoinTalk Thread

Web Site – BitcoinTalk


BitcoinTalk – GitHub

This is an opensource c# trading tool.

R2CT – The Round-Robin Cryptsy Trader


Gekko – a javascript trading bot for nodejs



GitHub – User Manual 

GoxTool can be used with a variety of “strategy” scripts for automated trading

Portfolio Rebalancing Strategy (


prof7bit’s stoploss (optionally trailing stop)


DonaBit’s improved version of prof7bit’s stop loss

GitHub – BitcoinTalk

Aido’s Improved version of prof7bit’s stoploss – Sells Full BTC Balance


piramida’s range trading bot



gweedo’s ‘Open Source bitcoin trading bot’


HAL 10K – PHP Open source Trading bot


Haasonline Simple Trade Bot

WebsiteLitecoin Forum – BitcoinTalk



LiquidBot is a Market Liquidity providing bot for MtGox.

PHP-BTC-e Arbitrage Bot (MadAlpha)





BitcoinTalk Thread


HN Discussion


Academic Research

Trading Psychology – Books to Read
Live Price Data
Historical Data
Generate a 15% Return with Bitcoin in Minutes. Free strategy guide.

Generate Passive Income in 2017: Bitcoin Passive Investment

How does the idea of generating a passive income, involving a relatively small monetary investment, a few minutes of your time per week, and seeing an income stream coming back to you within a day or two of your first investment? Sounds too good to be true?

Well, it’s actually possible, and doesn’t require taking on huge risks or having access to special skills or knowledge.

How? By passively investing with Bitcoin.

The below method is a very effect way of selling Bitcoin to PayPal, and get a 15% markup over the current market price of Bitcoin at the same time.

How does this work?

how does passive bitcoin investment work



  1. Purchase bitcoin on an exchange.
  2. Deposit your newly purchased Bitcoin into a Bitcoin lending service.
  3. Wait for your Bitcoin to be fully lent out (this step is 100% passive).
  4. Re-invest your initial investment, plus the fees you’ve earned, into buying more Bitcoin…
  5. Return to step 1 – lend your initial amount, plus fees, so your investment grows steadily.

As you can see, the process is very simple, and doesn’t take much time: buy Bitcoin, deposit it in a lending service, wait for your funds to be lent out, then take your initial investment plus fees, and use that to buy more Bitcoin, lend it out….and so on! You Bitcoin isn’t released until someone actually sends payment via PayPal, so your funds are fully protected during this process.

By the way, the terms “borrowing” and “lending” Bitcoin are somewhat misleading, is more accurate to say that you are buying Bitcoin at the market rate, and selling it with markup.

What is Bitcoin?
If you are not sure what Bitcoin is, I highly recommend this short introductory video: What is Bitcoin? 
Passive income has been a relatively loosely used term in recent years. Colloquially, it’s been used to define money being earned regularly with little or no effort on the part of the person who’s receiving it.

What is passive income? from Investopedia

Bitcoin is Highly Volatile – How Does this Qualify as “Low Risk Passive Investment”?

The beauty of lending Bitcoin is that you are exposed to very little price volatility because you only own Bitcoins for a short period of time – between the time you purchase the Bitcoin and the time it takes someone to “borrow” them for you on the Bitcoin lending exchange (they pay the market value of the Bitcoin, e.g. $100, plus some fees on top, which is what makes it so attractive for you as an investor). Usually, large Bitcoin price movements take several days or weeks to play out, so you are exposed only to smaller price movements. If you buy $100 worth of Bitcoin on Monday, usually you’d expect to have most of it lent out by Wednesday, with the cash on its way back to you in your PayPal account, ready to be reinvested back into lending out more Bitcoin.

How much can I Make Passively Investing in Bitcoin?

Let’s run through an actual loan to use as an estimate of how much you can make in fees, and plug those numbers into a spreadsheet.

Here is an actual, real-life example from my account:

$50 bitcoin transaction

Using these fees, I plug some hypothetical numbers into a spreadsheet to see what I could make from a $1000 initial investment, which I then loan out ten times (reinvesting all the initial amount plus the fees, so that the investment compounds nicely). I ignore the PayPal transaction fee that’s paid by the buyer, as obviously that part of the payment doesn’t go back into my pocket.

Note: expect most loans to be in the $30-$100 range, you are not going to lend out the entire $1000 at once.

bitcoin passive income p2p lending - return from ten loans

Not bad for just a few minutes per week of your time! By loan 5, we have already more than doubled our initial investment!

How long it takes to loan out your full $1000+ is difficult to say, as it depends on the amount of borrowers at any given moment of time.

Surely There are Some Risks and Drawbacks?

Yes, of course. There is no such thing as a free lunch after all. Apart from the risk that Bitcoin’s price could dramatically shift at very short notice, the other main risk is the fact that you are using PayPal- which in recent years has become riddled with scammers due to their crazy policies that favour buyers over sellers. This means that in the event of a dispute, PayPal will often favour the buyer over the seller (even where blatant fraud has taken place).

You can see the results of buyer disputes in this example from my account, which is the status after several weeks of lending:

bitcoin lending volume

The other main risk is that the buyer can initiate a credit card payback via PayPal, meaning that PayPal will charge you a fee to cover their loss, even if PayPal sides with you in a dispute.

You have to carefully consider these risks before getting involved with Bitcoin lending. Personally, I think the risk is worth it, even if I have to occasionally deal with some annoying borrower who suddenly decided they don’t want their Bitcoin, even though it’s already in their Bitcoin wallet and they decide to complain to PayPal.

What’s in This for Each Person?

  • For you, the lender – you generate a low-risk, low-time commitment side income. How much and how often you invest is 100% your choice – if you need funds back, you can cancel your lending at any time, sell your Bitcoin and cash out.
  • For the borrower – they get to purchase Bitcoin via PayPal, without going through the time and hassle of using a Bitcoin exchange
  • For me, the author of this guide – I make a small referral fee when you sign up to these services – at no cost to you. Also, I enjoy spreading the word about Bitcoin and cryptocurrencies, so it’s enjoyable for me to bring more people into the world of Bitcoin.

Ok – I’m Interested! How do I do this?

Initial Setup

These steps can take a few days, depending on how smoothly your ID verification is processed with the Bitcoin exchange, how quickly your initial deposit takes, and how much borrowing activity is going on at any give moment. The good news is you only need to do this once.

Step 1. Signup to a Bitcoin exchange. This is where you  buy Bitcoins which you will then lend to someone else. I highly recommend Coinbase* as they’re really easy to use and come highly recommended. You’ll pay a transaction fee for using a credit card to buy Bitcoin, however if you live in a SEPA (Single European Payment Area) country, you can actually deposit your investment without fees. Note that you need a passport or other form of photo ID to open an account with most Bitcoin exchanges.

*Note: if you sign up to Coinbase with this link, you get $10 in free Bitcoin when you buy your first $100 or more worth of Bitcoin from Coinbase!

Step 2. Signup for a PayPal account, if you don’t already have one.

Step 3. Signup to the Bitcoin lending website, this is the service that matches lenders and borrowers of Bitcoin. The service I use is Xcoins.

Ongoing Activities

As outlined above it’s really simple and only involves a few minutes of your time each week:

  1. Buy Bitcoin – 5 minutes or less
  2. Deposit it in the Bitcoin lending service – 1 minute
  3. Wait for your funds to be lent out – can take several hours to several days, depending on the amount you are lending, and the demand at the time. This is 100% hands-off, so no work for you! Personally I like to log in once every few days to check my balance and to check for messages (in case of problems), but how often is completely up to you. You will also receive email notifications regarding your transactions, so you don’t even have to login every time.
  4. Return to step 1! Purchase your initial amount + your 15% profit, and reinvest to steadily increase your profits over time.

Update –  June 2018 – FAQs

I’ve gotten some questions on reddit on this passive income method.

Question 1. What exactly is going on here? Why are people “borrowing” btc, secured with more cash than they are borrowing? The amount in cash + fees + interest is immediately in my PayPal. Why would people do this?

People are paying for the speed and convenience. If you’ve ever tried to register for a Coinbase account, you’ll understand the hassle it takes (take a photo of your passport with your phone or webcam, the software inevitably fails to recognise it or you did something wrong, takes 1-2 weeks+, back and forth with the support staff to sort it all out so you miss out on the latest price increase or whatever). Xcoins does this part manually if I had to guess, which dramatically speeds it up. You can also purchase BTC with cash via localbitcoins, but this is a hassle for many people and it’s a legally grey area depending on your country.

Question 2. Am I laundering money?

Absolutely not! There is a record of all transactions on Paypal, credit card statements and on the Bitcoin network, which makes this a terrible way to launder money.

Question 3. Do any lenders even care to be repaid? It seems like both parties would walk away from the transaction after the initial exchange.

No, as a lender you don’t care about being “repaid” despite the marketing material on the site 😉 The part that’s interesting is selling at a markup, and being able to repeat this over and over (“walking away” from the transaction each time). I think it’s described like this on the site to avoid calling themselves a p2p exchange or equivalent. Basically you can keep purchasing BTC via Coinbase (or any other exchange of your choice) and repeat as often, or as little as you like. In Coinbase you can set a recurring purchase amount, e.g. 100/1000/X amount every week, and then simply login once a week and transfer the BTC to your lending wallet (takes probably 2-3 mins max). Then is lent out automatically, you make 15%, you get the USD funds in Paypal….buy more in Coinbase…send to lending account….and so on.

Question 4. You mention that it’s passive. So, I have people’s money in my PayPal. Do I just purchase more btc from Coinbase or someone with that money and repeat the process?

When you get paid via PayPal you can simply cash out the profits into your bank account, or buy more BTC and reinvest. That’s what’s so great about this strategy, your funds are not locked up for long periods – the money is yours once it hits your PayPal account! (The only exception is fraud, which sadly happens every now and again, which I mention above).

Question 5. How would I report this on my taxes?

I strongly advise talking to an accountant or tax advisor for your country. It probably fits in a tax category similar to an item that you flipped for a profit on eBay.

Question 6. How much do you think you should invest in flipping Bitcoin?

Usually it takes 1-2 days to full sell ~$150-$200 worth of BTC (it depends on the demand at any given time). You can start with a minimum of $20 though, so try that to get a feel for how it works. You can always buy and loan out more if you wish.

Question 7. How long have you been doing it for and what has your ROI been?

Roughly two years or so. ROI is tricky because when I cash out with Paypal, I get completely screwed with their USD to EUR exchange rate. You officially make 15% per transaction though if you’re cashing out to USD, assuming your don’t get with hit with too much fraud, your ROI will be around that. It’s not risk-free, but it’s far easier and less stresful compared with trading, since you don’t have to actively do anything once you setup your loans.

UPDATED GUIDE - Generate Passive Income In 2018: Bitcoin Passive Investment

This new, fully updated, 2018 guide contains all of the information from this 2017 guide plus the following additional information:

  • Adjust your account settings to reduce the risk of losing money to fraud
  • Two additional passive income streams
  • Details on how to quickly get started with affiliate income
  • Details on how to quickly get started with crypto lending
Yes, take me to the Bitcoin Passive Investment guide for 2018

Find out why using xCoins is an effective way of cashing out Bitcoin to PayPal.