CoinTrek – New Year New Me!

I have been out a while folks.  I have been working a bunch of things, but the important part is my life has stabilized.  I’ve moved, started a new job, and among other things generally have been adjusting.  Now I’m ready to jump back in!

Moving forward…

Originally I had set out to earn a Bitcoin. One single bitcoin.  The more I’ve thought about this, the more I believe that I have narrowed myself down into a corner too much. Leaving little room for growth.  I have put a lot of thought into what CoinTrek and I’ll be coming up with a new angle soon. The reason for this is I’ve asked around the community and decided it best that I find a good niche, dig in, and become more consistent.

Coming up… I have a few accomplishments that I want to share.  In the past couple of months, with the time I did have, I’ve built a mining rig and have started earning cryptocurrency.  The learning experiecne is good, and I still want to share it.

Also, I can see I’ve built up a few followers! I’m really thrilled to have you all.  So, moving forward I’m setting a couple goals for myself:

  1. Devising a new and better angle for CoinTrek.
  2. Regular blog posts – I’m going to shoot for about every two weeks.
  3. Sharing the past couple months of learning with you.
  4. Creating a CoinTrek path for any “coin-trekkie” out there.

As always, if you have something specific of interest. I’m happy to write my thoughts on it. Drop me a line!

P.s. – My Bitcoin gauge is neat but it might become a gauge for something else! Stay tuned.

CoinTrek – Quick Update

Hello Everyone! I admit silence for a little while now.  My goal is to start writing more frequently and more regularly.  At this point in my life I am in a transition so its very difficult for me to write.  Once I get settled, I’m going to dig into a niche and do it very well.  I hope this happens very soon as I enjoy writing about a topic I enjoy and helping everyone learn!

Captain’s Log 005 – Keeping the Books

Trying to make money through investment is pointless if you’re not keeping the books! How would you know if you were making money, or losing it? I struggled with this. Before I even began purchasing crypto to add to a collection I did what every good engineer does. I made a spreadsheet! In this blog post, I will walk you through creating a spreadsheet to keep track of your cryptocurrency. The spreadsheet will do three things; serve as an input for your holdings, maintain live pricing for each of your holdings, and keep a of log your transactions so you’ll know what your gains or losses are. There are apps out here that will do this for you, but for me having tight control over maging my crypto was important. Also, I a do it yourself DIY oriented. Using an app was analogous to checking my work more than anything else.

Enter the power of a spreadsheet! For this blog post, I’ll use Google Sheets. One might use Microsoft Excel. For the most part, the formulas used are the same. I came up with a three sheet flow. From left to right I have a sheet to track all my wallet amounts, an index tracker, and a transaction log. There is also a fourth sheet which I use to source information for coin prices and market capitalization data. I realize not everyone is spreadsheet proficient, so I will do my best to explain formulas as I go. If you find yourself misunderstanding me, please drop me a line and I’m happy to go over something with you.

To start out, I’ll go over how one might consider tracking their wallets information. I am not talking about private keys, rather just the amount of coins or tokens each wallet has. This is where inputs go. Two things to think about how I track wallets. A single wallet contains all your coins, true. However, you might want to look at them in different buckets in a financial sense. For me, the two buckets were an index portfolio and the other was for long term hold.

You can see here the example has two Bitcoin addresses; two wallets. I left a placeholder for the receive addresses and a link column for linking to an address scan tool, such as [1]. Honestly, those two columns are there for extra info and I like having it there for my reference. Next two columns hold quantity data or how I want to split the funds in the same wallet for tracking purposes. The index quantity is the portion of the wallet funds I want to put in my index portfolio, and the hold quantity is excluded from the index and treated separately. I did this originally because I knew that some of the coins I was investing in would be held for a very long time, and I didn’t want those to skew my index weighting. Lastly, a subtotal row adds up the quantity columns and a final total beneath that. I have noted what each wallet is for reference. Obviously, you’d repeat this for multiple coins.

Before I jump into tracking an index, pricing information is needed. Before I learned the formula I’m about to share with you, I was entering the data in manually. There had to be a better way. One of the earliest sources of pricing information I came across was the coinmarketcap website; [2]. You get lot of good information there, but it is not the only source out there so I encourage you to hunt for others should you wish to do so. I discovered the “IMPORTHTML” formula, and on a seperate sheet I entered:


Google sheets takes the website URL and the arguments provided to extract the table information for table 1. On coinmarketcap, the first table contains information for coins 1 – 100 kept in order of which coins has the largest market capitalization by default. If the argument ‘1’ was changed to ‘2’, then the table would be imported would be coins 101-200. What I did was repeat the formula for the first 300 coins. I spread the formula by 100 rows to avoid overwriting tables; Eg table 1 formula goes in cell A1, table 2 goes in cell A101, etc…

Here is a screenshot of and beneath it is the imported representation in the spreadsheet.

With the information organized neatly into rows and columns, you can now search create an index spreadsheet that uses the data.

If you recall from my previous post on indexing your funds, you’ll know there are many different ways to do it. Let’s assume for the moment you have 10 coins you want to create an index portfolio about. In one fashion, you could buy an equal amount of each coin. That is if you spent $100 on each coin for a total of $1000 overall, then you have weighted each coin by 10%. This is an equal index strategy. For simplicity’s sake, it is easy to use but you don’t get full market exposure doing so. Another way to do it is by weighing each investment by market capitalization. The bigger share of the overall market an asset has, the larger share of the overall portfolio yours takes. A benefit to using this strategy is a more complete exposure to the market and therefore better chance your portfolio will go up and down with the market overall. A disadvantage is the blend of the funds you put into the index. Let’s say you only chose coins with a large market capitalization, such as Bitcoin, Ethereum, and Ripple. You have large capitalization coins in the index, but you’re missing out on the other middle and smaller capitalization funds. One might take the market capitalization index strategy a step further by choosing coins that are a blend of large, medium and small capitalization. Check out investopedia for more information on indexing, if your curious [3]. To be clear the spreadsheet method I use contains this market capitalization strategy.

As a rule, just because a coin has a large market capitalization, that does not generally mean the coin price is stable. Volatility is prevalent in all areas of cryptocurrency trading, so do your research and pick coins which you believe in. Don’t just chose the big players. Give the little ones some attention too! Imagine if you had done this with Amazon before a share of that stock was worth $1000 like it is today; roughly. A good example is Siacoin [4]. They were a small fish a year ago when they first started, but they’ve earned a larger share of the market as their technology has evolved. I’m not saying buy siacoin, but rather using it as an example of a small cap coin that grew from $0.002 to $0.03 over time.

In this example there are five crypto assets with example data in the amount column. I wish I had that much! Now, tracking your portfolio on a spreadsheet can be done by sourcing the index data from your wallet sheet. That way you don’t have to input your wallet amount twice! To do this enter:


Where inside the is the name of the sheet you stored your wallet information and A1 is the cell of the subtotal that is for your index fund. There is a seperate section dedicated for coins to be held, but the data is sourced in the same manner.

Here’s where more formula magic occurs. One could simply use the same method as getting the coin amounts from the wallet page with the live price and market capitalization, but as time progresses the data changes. That means, if on your coin info sheet you reference a row for a coin then you’re actually referencing that row in the sheet not the website. If that particular coin changes and moves up from say position 10 to 8 overnight on the website, now your sheet is wrong because the 10th row in your spreadsheet is now some other coin when it updates. Why is this a problem? Because if you’re like me you want to automate this process so you don’t have to spend 10 minutes scratching your head about why your spreadsheet is wrong!

Here’s the solution. First, since the position of the fund might change rows in the spreadsheet, that means you’ll have to go find it every time just to be sure. But, how do you make a spreadsheet do that? Nifty formulas you spend hours researching of course! If you use the coin name as an input, you can write a formula that will find the index in the spreadsheet and extract the value of interest.

If you look at the screenshot where “BTC Bitcoin” is entered you can see that on the coinmarketcap spreadsheet that was imported. The spelling must be exact!


The formula reads as such: Match the coin name in cell B2, which was “BTC Bitcoin”, to the entire column with names in it from the coinmarketcap spreadsheet. The match function returns the row number of that coin in the spreadsheet. Then that result is fed into the index function which simply reads, “at the index row where ‘BTC Bitcoin’ was found, go over to the D column where the pricing information is and pull the data”. For the uninitiated, the ‘$’ signs in spreadsheet speak means to always reference that cell when you copy the formula. Otherwise if you copy the formula one cell to the right D2 would become D3 if you didn’t use the dollar sign. Repeat this for the market capitalization information. That means the column D will change to a different one where the market capitalization values are.

Now with the new pricing information, one can multiply the number of coins by the price to obtain the current market value. To see portfolio allocation, divide the market value of an asset by the total portfolio value. Using market capitalization data, do the same thing in another column. Divide the market capitalization of one asset by the total of all assets. You will have two numbers. An actually portfolio weight for an asset and a market weight. You’re attempting to match them. The extra two columns, “drift” and “OK?” can be programmed to tell you how much your are off by. Simply put it’s a difference of actual versus desired. What you’re off you get to the hard part! Rebalancing.

I’ve made a rebalancing calculator which takes all the index funds and calculates how they are to be spread in terms of value to reach the market capitalization weights. To achieve this information, take the total market value of all assets and multiply them by the percentage of market capitalization from the desired weight calculation in the target allocation column.

The hard part now comes in the form of selling your shares appropriately and buying back in with other assets to achieve the value calculated. Given how volatile each asset is, one might choose not to do this but once a year or however long is appropriate for you. To give an idea of bitcoin volatility, check this website out here [5]. The calculator can be used similarly to see how much of each asset to buy everytime you invest a dollar amount. My methods tend to be a bit haphazard at the moment where I buy a coin in an amount and add it to the portfolio. I fully intend to rebalance in the future once I ride out the market for a bit. At that time, perhaps, I’ll cover the procedure.

The index sheet shows you how your overall portfolio is weighted but it does not tell you how well you’ve done. Therefore last but not least comes the transaction log where you must enter in buys and sells.

In this example a series of bitcoin purchases are made and a sell. The amount price and amount column tracks the data on the day the transaction occurred. Buys are positive and sells are negative. In the market value and total columns the same thing happens but these columns track the current market price of buys and sells as if you sold it the day you looked at the sheet.

To get a cost basis, add up all amounts in the amount column. Similarly, the same for the market value column. Earnings or Loss is calculated by the following formula:

=if(K3-K2 > 0,(K3-K2),(K2-K3))

Using this formula ensures that a number with the correct sign shows. If the current value minus what you bought it for (cost basis) is positive, show that value, otherwise reverse the subtraction. The percentage is calculated by dividing the current value by the cost basis and subtracting one:


I have taken my spreadsheet and made a template out of it and left it for you to use here:

Anyone can download it and reuse it to their liking. I am always working to improve the spreadsheet, so if you have updates or suggestions please email them to me at:

cointrekkie [at]

Or, comment below and let me know how to get in touch. Twitter and Facebook also work if you prefer to use either of those.

I use a tool at his website to check my work and I invite you to play around with it too: [6].

Right now my index portfolio is making good gains in the market and that’s where the bulk of my progress is right now “on paper”. At the time I didn’t have the money to run out and buy mining equipment, but that is coming soon! In my next blog post I am going to cover purchasing Ripple XRP because my followers have asked me to do so. I hope this information has given you a tool to track your investment progres, or at least armed you with the knowledge to create your own method of doing so. My purpose it to become knowledgeable about using cryptocurrencies in all manner, earning it and teaching others about it. I realize most of my posts so far have lended toward investments but intend to start diving into earning and usage in future posts.



Captain’s Log 004 – Predictable Passive Power

The three P’s. Predictable, Passive Power! I made these up! I did not read them in a book anywhere but I did read several books on Finance. These days I have spent a lot of time in a car and I have listened to a number of audiobooks. What is an investor? My answer is someone that’s not trying to make a quick buck but rather sees potential in something and wants to be a part of it. Let me emphasize that last part. Being a part of your investment. What? All too often I see people wanting to drop a few dollars and get immediate and enormous returns! Investing is not about that. You have to own what you put your money in. There are strategies for doing this, and in this blog post I’m going to tell you about mine. I’m going to tell you about a predictable way to make money in markets, a passive way to do so, and paint a picture for you about the power of investing!

My interest in finance started when I realized how poorly my own retirement 401k was doing. I had not the slightest clue what I was doing. The average person gets zero help making decisions on funds to pick. You get countless links to useless online resource guides full of complicated terminology. Actually, if you don’t make decision, your company does so for you and sticks your retirement money in a Target Date Fund! This usually happens but not always. Yikes! High fees and mediocre performance. About a year back I read this book called “Money Master the Game” by Tony Robbins [1]. A good read if you’re interested in a new mindset or looking for new ideas. There’s a lot of repetitiveness in there but the book put me in the right mindset, and it led me to other books. The book I was led to is called “The Little Book of Common Sense Investing” by Jack Bogle and that gave me the knowledge to put together my own investment strategy [2].

Remember the crypto-realm is full of odd terms like Hot and Cold for wallets? Well there are also a host of acronyms? Some of them are really silly sounding like FOMO, or Fear of Missing Out. A lot of people fall victim to this one. Wanting to rush in after the wave of a particular investment opportunity is heading toward its peak. In a good book that I’m currently reading, “A Random Walk Down Wall Street” by Burton Malkiel I learned about the Greater Fool Theory[3][4]. There always has to be a greater fool willing to buy what you bought for more than what you paid for it, and that can only go so far. Not knowing when that will happen has caused me to lean back into the investment strategy that I use; passive indexing. I use a buy and hold strategy. Crypto followers called this HODL. No that is not hold spelled incorrectly. Rather an acronym to mean hold on for dear life because the cryptocurrency markets are volatile like roller coaster is.

If I went around and looked for a needle in a haystack I will have a hard time trying to find it. That is analogous to hunting for the next big winner. For instance, there are dozens of Altcoins that are priced very low and one could easily jump in on and win big. But, which one? Seeing as one cannot possibly know which one or where the needle in the haystack is, what is there to do? My approach. Buy the haystack. Yes. Do not try and guess where the needle is. Departing from that analogy, one can apply this with securities. Ever hear of the Standard and Poor’s 500 or S&P 500? Well that is a collection of 505 stocks issued by the 500 companies that it includes under its index [5]. The money in the index is spread out over all of those companies with a weight to each. This is wonderful because if any one of those companies fails, the entire index will continue on. The idea of an index is spreading risk out among many securities instead of a handful, and it works just as well with cryptocurrencies as it does with stocks.

Why is this better than trying to chase big winners and constantly buying and selling to beat the market? That is to gain more by actively trading than the market would on its own passively. I do not want to get hung up on numbers. You can go do the research yourself, but I do know from my own research that when funds managers try to beat the market, they fail over the long term. Yes, I’m talking about Mutual Funds. They’re expensive to hold with enormous fees and the fund manager tries to actively beat the market. Two things, one you can’t beat the market (better than the S&P 500 or similar) consistently over many year; 30 plus years. Very few mutual fund managers have pulled that off. I don’t have a reference for that, so I challenge you to go find some that do and wish you good luck. I digress a bit here but I have to make due diligence. The second, is fees. Fee’s will erode your returns for as long as they’re held. Since they’re unavoidable, I’d keep them as close to 1% or less. In the context of a mutual fund, one pays these fees to the fund manager. In the realm of crypto your fees consist of transaction cost to make trades.

A passive strategy over the years will produce a consistent result. Remember, one’s goal is not to chase the market risers which are rising and falling all the time. Eventually you’ll guess wrong and get dropped like a rock. Pick a collection of crypto assets and split your money across them. Believe it or not, there are even strategies for how to pick and split money across the collection of assets too. Pick cryptos you’re really into. That’s what I do. If I find a cryptocurrency that I really think has a good fundamental value to it. I try to get in on the ground floor, that is, early on. However, if a security is priced at a specific number and you feel that is a good price then go for it. Once I have picked a crypto asset, I’ll invest and hold on to the asset no matter what the market does. The market will do the rest passively. I am in the market for the long term. An investor!

A word about advice. I am not a person that is qualified to give investment advice. I have not listed any assets that I’ve picked myself, but I may talk about some in a later post. I am merely a person telling you how I go about investing, and you are under obligation to yourself to do your own research. I really must emphasize research. I read about crypto every day and keep up to date with market developments as best I can. An investor is obliged to stay current, and so am I. Cryptocurrency markets are extremely volatile so be careful!



Captain’s Log 003 – Wallets for days!

Wallet, wallets everywhere. What to choose, a hope and a prayer. That was how I felt looking for my first cryptocurrency wallet. Since the inception of Bitcoin countless developers have made wallets for it, and the numerous altcoins each have their own. All of them claiming to be the best thing around. I must have read a dozen articles about it and watched just as many YouTube videos. My first Bitcoin purchase of $100 was sitting on my Coinbase account and, at the time, that seemed like the most logical place to store my money. I had this feeling like I had lto get it into my hands. In this post you will learn what a wallet is, how it operates, the different types and where to get one. I’ll let you know what I use too. After reading this you should have an idea of what sort of wallet you might want to use.

Before diving in I need to say this about wallets. This is the mother of all rules when it comes to wallets and I cannot emphasize this enough. If you do not possess the private keys, then it is NOT your wallet! I mean that in the most explicit and seriousness of tones possible. Everyone that lost their money on the Mt Gox [1] exchange or the NiceHash hack [2] learned this the hard way. Trust me. I was one of them. I lost a month of mining earnings on NiceHash in that hack. Thankfully it was only a few bucks. You might be wondering what is a private key? Or, I thought we were talking about wallets? Well, I need to explain what that is exactly.

To understand what the term “Wallet” is in the realm of cryptocurrency I must explain to you how one functions. First, shed all notion of the traditional concept of a wallet because the name does not own up to what is actually happening. A wallet handles what I am about to explain to you and gives you a lot of pretty buttons to use while you’re doing so; enter another piece of software. All coins or tokens belonging to a cryptocurrency must live at a certain address that is yours, and that address is accounted for on the blockchain. Here is an example of a BTC wallet address I created at

E.g. My BTC Address in the sidebar of this blog: 1CAiRgo2KcXQehsC2PdiPEmjMHECJhvriK

Good luck remembering that thing by memory! This address is public and is what you give to others to receive a payment, and the private key is even longer. All transactions made are visible publicly on the blockchain or public ledger. That address did not just come from anywhere, however, it is generated by a random seed and comes with a private key pair.

The private key is how you sign transactions on the blockchain. A transaction consists of three items; A destination address, an amount to send, and a signature [3]. All of these make up a piece of information that is sent out to the network to become a part of a block to be mined and added to the blockchain. A wallet is your window to controlling your interests on the blockchain.

Here’s a good analogy. You can think of your wallet like a mailbox. This is your public facing address. Everyone can send you mail if they know where you live. Also, anyone can look into your mailbox and see what’s there, although I hope my neighbors aren’t snooping inside! Can’t somebody just steal your mail? Well, yes but let’s say ours is a P.O. box with a key! Now, usually, to send mail you put it in your mailbox for pickup or a drop box. We all know our mail isn’t going anywhere without a stamp, right? So, think of that stamp as your signature. Obviously, the contents of the mail is the digital currency you’re sending.

Not too hot and not too cold… Yes, there are types of wallets, and they’re not associated with temperature.. A hot wallet is on that either lives on a hosted website or on a device. If the hot wallet is hosted by another site, then you by default do not own the private keys and your money is not in your possession. All exchanges operate this way. Do not trust an exchange or website to keep your money safe! They can be hacked! I don’t even trust Coinbase to do this and they’re about as reputable as it gets in the USA for an exchange. The other type of hot wallet is a the kind that runs on your mobile device, like Coinomi [5], or your desktop, like exodus [6]. For the record, I do not endorse either of those software host wallets. They are merely meant as an example. The hot wallet types are versatile, convenient, and, usually, easy to use. However, this wallet type is only as safe as your device is. If your device, desktop or mobile, becomes compromised then your crypto is at risk.

I don’t know about you, but I am not a huge risk taker. I’m not risk averse, but I do prefer to mitigate risk whenever possible. You’ll see this when I get around to talking about indexing my crypto assets in a later post. Why would you prefer a cold wallet over the convenience of a hot wallet? I’ll tell you the answer is peace of mind. A cold wallet is one that is not connected to the internet or any device such that the private keys can be transmitted electronically. There are cold wallets that take the form of paper. You literally cannot hack a piece of paper! Unless we’re using a pair of scissors, your private key can be safely stored away in your filing cabinet if you so chose. I don’t like typing in long characters off of a piece of paper, so I’d rather have something manage that for me. Yes QR codes do exist, but who wants to have to pull a piece of paper out of a safe every time you want to scan it? The use case for paper wallets is limited to people wanting that sort of security, or to ATM devices that dispense your money is such a manner.

Enter the hardware wallet. I personally use a Ledger Nano S to safely store my crypto assets [7]. If you want to help me out, you can use the link in my references to obtain one and the referral should help me out. To give you other options, there are the Trezor[8] and Keepkey[9] wallets. I have never used either of those alternatives, but I read they are comparable to a Ledger Nano S. The device I use plugs into your machine via USB. You must enter a 4-8 digit PIN number to access it, and to make a transaction you must physically push a button on the device. If someone obtains your device, it will erase itself after 3 or 4 unsuccessful attempts. If someone takes it apart, it is tamper proof and will erase itself. Even if my desktop gets hacked, the ledger does not transmit the private keys to the compromised device. And, the best part! If a car runs over it or it gets incinerated, you can regenerate your wallet on another one! That’s worth the Approx $60 I spent to get one to me. I’m probably going to pick up a couple more to keep as back ups later. You must decide whether to go hot or cold.

A word on keeping your private keys safe. Regardless of the wallet choice you are still responsible for safeguarding the private key, or the seed that generated it. Seed? Wallets don’t have seeds in them? Some wallets generate the private key directly and then you store it somewhere safe. Other wallets generate the private key based off of a seed phrase you give it. For instance, the Ledger Nano S generates its public and private key pair off of a 24 word passphrase that is unique to each device issued. Forget the phrase and you will never regenerate the keys. That’s worth safeguarding! If you find yourself with a seed. Do yourself a favor. Write it down and put it in a safe. Seed or long giant private key; regardless of wallet type. With the power of being on your own bank, you are responsible for getting this right!

I added a progress gauge to the sidebar of this blog. The gauge is live and updates on its own! I’m still sitting at a whopping 0.018 BTC! Yay me! I am actually making progress just not in terms of BTC. I’m mining Ethereum and Making headway in my crypto asset portfolio. I just haven’t converted anything over to Bitcoin. Honestly, I’m wondering if I should? Once I work my way up to 1 ETH, I’ll use what’s left over and convert it. I sort of like to have at least one of each for investment purposes.

Until next time! I hope you now have a thorough understanding of wallets. If you have a topic you want covered or a question. Feel free to contact me on my Facebook page or Twitter!



Captain’s Log 002 – Making a Market Master

The first time I got on an exchange other than Coinbase[1] and bought an Altcoin was an anxious and tedious experience. There were so many buttons with terminology I did not understand, such as limit, bid/ask, fees etc… From my perspective, I had just learned about Ripple XRP and I wanted to get some! I thought it would be as simple as handing over my dollars and receiving my new currency. Wrong! I had to learn my way around an exchange that did not make a fancy abstract graphical user interface tied to my credit card. I wasn’t even trading dollars actually, I was going to trade Bitcoin for the XRP.

I’ll tell you why I went this route. Some of you are thinking, why didn’t this person just use Changelly[2] or use Bitstamp[3]. The first reason is, I simply didn’t know of their existence at the time I did my first market purchase. The second reason is I had Bitcoin I had earned and wanted to trade it for something else. My first rule of investing is as such. Do NOT invest money you do NOT have. Period! The way I treat investment is considering it as if it were a total loss at the time of vesting. I have to be willing to lose that money entirely. Therefore, the Bitcoin I had earned through a mining marketplace company called Nicehash was currency I had earned, and I didn’t have to add more to the pot from my bank account.

In my last post I had mentioned that privacy is subjective to the user. One must decide if handing over their personal information is unsettling or not. I was okay with this when I made my Coinbase account. However, I felt that doing this once was enough and I felt more comfortable using a USA based exchange doing it. Finding an exchange that dealt with altcoins while simultaneously having a low barrier to entry was important to me. Name and address was okay with me, but I didn’t want to have to fork over my drivers license and birth certificate to make a single trade. I must have googled “altcoin exchange” about a dozen times before I found Bittrex[4]. This exchange was going to let me do what I wanted without needing to know everything about me. Later I learned about Binance[5]. In my opinion both are equally private and useful.

In this first experience, I went headlong in without doing enough research to understand fully how to proceed. In my mind the money I was risking was for education and I’d learn as I went. My first lesson came in the form of confirmations. Bittrex requires at least 2 confirmations of your Bitcoin transaction before crediting the funds to your account. Cue waiting time! An hour later I returned and found my Bitcoin available for trade. Afterward I navigated over to the trading page for the BTC/XRP exchange pair.


I don’t know about you but my brain works in USD not BTC, so looking at the marked information for the last trade in an alternative currency was a bit of a switch. I found myself constant keeping track of the conversion between BTC and USD. Fortunately, the conversion is there for you but it’s interesting to note how much my brain clung to the notion of dealing in dollars. Looking at the information I deduced that “LAST” meant the last trade that settled, but I wasn’t sure what “VOL”, “BID” and “ASK” meant initially. Google is your friend. Volume or “VOL” simply meant how much had been traded in the past 24 hours. There’s more to it than just that because one can learn a lot about a coin by its volume. Long story short, you want to work with a currency that is traded. If there’s a low volume then that means nobody is trading it so you would have a hard time buying and/or selling that item. Next “BID” simply meant the most anyone in the market was willing to buy for, and “ASK” was the least current sell price. That’s why it’s a market right? You have to meet in the middle somewhere, only who is going to do that is anyone’s guess.


A little market terminology on orders. An order is a person’s intent to buy or sell at a given price. However, there are different types of orders and I’m going to tell you about the two simplest and why you might want to use them. First, you have the market order. Imagine you’re doing the shopping for a fresh fish and you’re pressed for time or money isn’t an object for you. What do you do? You go to the grocery store and buy the fish at whatever the fish is selling for. No haggling or questions asked. Settlement is pretty easy in this situation. The advantage is you get your fish pretty quickly but you might not get the best price in town. The second order type is the limit order, and these get a little more tricky. The limit order may come with a time limit on it or may be good until you change your mind. Using the fish analogy, imagine you’re sure that the fish may be purchased elsewhere at a better price and therefore you decide to hold out. Once can do that on an exchange with a limit order. Your order might not go through immediately because there may be others willing to pay more than you are for the same thing to the same sellers. What you are doing is betting that eventually that pool of people willing to pay more will dry up, or those selling will decide to sell lower all of a sudden. Either way, you put a limit on your price.


Playing around with limit orders is fun! I really enjoyed seeing how little I could get away with paying for my XRP. I must have waited an hour but eventually the number of folks willing to pay more than I did waned and sellers gave in a little. The fun part is you get to watch this play out on the order book. Your order usually gets a star next to it or something to make it stand out to you. The user interface on exchanges are going to vary but the concepts are the same. For example, on Bittrex, I would place a bit at the last price for a market order. There is no “market buy” button.

A word of caution about dealing with exchanges. Two big ones fees and wallets. Do your homework and read the fees pages thoroughly. I wish I had done this my first time. Every exchange, will charge two types of fees. The first being a trading commision. This fee will vary exchange to exchange. For example, Bittrex charges 0.25% on each trade you perform regardless of the amount. The second one is more important, withdrawal fees! I had no idea that the exchange was going to charge me 5 XRP just to withdraw my money!

Regarding wallets and exchanges…. Never leave your money on an exchange and be careful about which wallet you chose. I cannot stress this enough. If you do not possess the private keys to your wallet IT IS NOT YOURS. I will not trust an exchange to store my money. They are not bank accounts.

My bitcoin meter hasn’t moved because my latest round of Bitcoin earnings was lost when NiceHash was hacked last week on 12/6/17[7]. I suppose that’s yet another post; mining!

Until next time! Feel free to comment with questions, or drop me a tweet on twitter! I use my blog and twitter the most with the occasional YouTube video.


  1. Coinbase –
  2. Changelly –
  3. Bitstamp –
  4. Bittrex –
  5. Binance –
  6. Ledger Nano S –
  7. NiceHash Hack –

Captain’s Log 001 – Where I started & My Bitcoin Progress Gauge.

Where to start in crypto and my progress gauge

There is a plethora of information to get people started obtaining bitcoin and most other altcoins.  Almost too much information.  This world is so busy everyone wants a piece of the proverbial “pie”.  After I made the decision to buy my first fraction of a bitcoin I started looking for a place to do this.  Cue up the dozens of “Where to buy bitcoin” Google searches.  What I found was a cacophony of choices and routes one can get bitcoin.  In this post I am going to break down all of the various choices of cryptocurrency exchanges and then walk you through how to store it safely.  

Enter the exchange and lots of choices.  I would later find out that the exchange was just a fancy way to say a market with a pretty user interface. Exchanges are where you swap your hard earned “fiat” currency for a crypto-asset.  I had no idea what the word “fiat” meant either and as a result started looking at exchanges of all types not knowing some accepted it and others did not.  For the uninitiated, “fiat” generally refers to a currency backed by a government.  

Simply put, there are categories of exchanges out there.  In the first category there are the exchanges that are controlled by an entity or organization and those fitting such a group convert currency differently.  The first kind is an exchange that deals in fiat currency and trades it for crypto.  For example, a very well known exchange that does this is Coinbase. Not promoting them but that’s an example.  The second sort of exchange does not bridge fiat. Instead it assumes you already have crypto and want to swap it out for another cryptocurrency, specifically one of the many alternative coins; altcoins. You have to transfer Bitcoin or Ethereum to it and then trade it for other currencies or tokens.  An example of an exchange like this is Binance or Bittrex.  In the case of Bittrex, you can go through a more rigorous vetting process to exchange in fiat there, however, I have not done this yet.  Outside of exchanges controlled by an organization are the peer-to-peer exchanges.  Some of them are run by a controlling authority and others are open source, for example Cointal and Bisq, respectively. Both have their pros and cons a there are dozens of choices for each! Where do you go?

What to consider.  For me it boils down to two bigs ones.  Do you want your transactions to hold your name to it or not? Me personally, I have nothing to hide so I don’t mind. A company like Coinbase is going to vet you and give you a buying limit based on whom your are.  Meanwhile, peer-to-peer trading platforms use a trusted third party ebay-like system or have a built in method for handling it. Think trust-less.  Among all exchanges, unless you’re totally doing this in your backyard with your neighbor, you’re going to pay a fee and that brings me to the second.  Do you want to pay big bucks to swap your currencies or not? For me, I’m not opposed to dealing with a company like Coinbase because they have a simple user interface.  To me that’s worth the 4% fee they charge when you use a credit card to buy.  

If you’re clueless and want a simple place to start, just check out coinbase.  There’s a whole extra side to all of this, which is the question of “How the heck do I place a market order?” if you don’t use a simplistic exchange to tackle too.  I’ll talk about that in another blog post.  

For me, I am using Coinbase and GDAX.  If I want instant buys, that is something I hadn’t planned for. More specifically, a hypothetical dip on Ethereum, I’ll use Coinbase. Long term if you plan to buy a certain amount each month then I use a bank transfer, wait a ridiculously long period of time, and finally trade on GDAX because it’s cheaper to do the market orders yourself than to go through the simplified user system that Coinbase offers.  

I’d like to write another blog post about storing your cryptocurrencies, but suffice it to say I don’t trust an exchange to keep my crypto safe and neither should you. I’m a computer geek but I’m paranoid about losing a hard drive, so I opted for a hardware wallet.  

To tell everyone where I’m at, I have amassed a whopping ~0.018 BTC! That’s after a few months of mining and learning where and how to obtain crypto and store it safely.  Most of that I’ve earned through mining.  I even made a pretty gauge to show my progress.  Side note: I love graphs because I’m an engineer. I have a long way to go, but that’s okay! 



My resources:

I’ll be honest, some of these are referrals, but the way I see things using it is a win win for both of us.

CoinTrek – Introduction

I am on a CoinTrek…

If you’re like me and found out about the crytptocurrency world a little while after everyone else did, guess what?!? You now have an enormous hill to climb up. That is unless you have the ability to buy your first Bitcoin outright. How can a person with no knowledge of crypto go from nothing to earning a single bitcoin? A few months? A year? Maybe longer? I put emphasis on earning. Nothing given to a person is ever valuable, and I am only interested in earning a bitcoin.

The purpose of this blog is to chronicle how an average person got started and worked up to a single Bitcoin. I’ll take you on a journey with me as I learn about cryptocurrencies, discover sources of information and use them,  build computers on the technical side of the house, and create my own cryptocurrency portfolio and manage it along the way. After I reach this goal, I intend to use what I’ve learned to help others interested in doing the same.

A little about myself to give you an idea of what kind of person is undertaking this venture. First and foremost, I am a science fiction geek. Hence “Trek” in the label for this whole thing.  I am an engineer by trade and I have lots of technical skills and knowledge when it comes to computers.  I read finance books on the side for kicks and I have a large interest in aviation.  To put it simply, my hobby is learning! I am an information sponge.

To set the record straight, my goals are:

  1. Earn a single bitcoin.
  2. Build a solid crypto-asset portfolio.
  3. Learn as much as I possibly can!!!
  4. After I earn my first bitcoin, continue on to help others do the same!

Moving forward I am setting a couple rules for myself:

  1. I will not buy an entire bitcoin outright.  I may buy a fraction of a bitcoin here and there in an attempt to benefit from a market gain, use a service, purchase a product, or trade for altcoin(s). One exception is a monthly investment because in my mind that’s the same as benefiting from a market gain.
  2. I will not accept an entire bitcoin as a gift from anyone or anywhere and say I earned it.  This is supposed to be something I am doing on my own.

Here’s what you’ll see me doing to achieve my goal:

  1. I will learn about markets and trading to achieve gains!
  2. I will mine! Slow at first then gaining momentum.
  3. I will perform tasks or services for Bitcoin or other cyrptocurrency provided it is legal.

I am enthusiastic and eager to embark on my endeavor.  I want you to learn as much as I do. So let’s do it! Come and join me on my CoinTrek!