Categories
Uncategorized

Blood Pressure 5 Day Record Form

I’ve written a 5 day blood pressure record form for my father. The one that was provided by the doctor wasn’t very intuitive.

You can access it on Google Docs here : https://docs.google.com/spreadsheets/d/1pUDhr3YuVaerV4CJGScBGCSyO4KwNSNFO8rITQTj0rM/edit?usp=sharing

Categories
Uncategorized

Freetrade Dividend Overview Spreadsheet

If you have a Freetrade account and want to keep track of your dividends in a simple table / graph, then I have written a Google Spreadsheet to help.

Step Instruction
1 Got to the Activity Tab on the Freetrade app
2 Click the Share icon in the top right corner
3 Select all activity
4 Select Gmail, or similar, to email it to yourself
5 Clear everything in the Full Export tab
6 Open your export in Google Sheets, copy all data
7 Paste the data from the export at the first cell the Full Export tab
8 View your dividend overview on the Dividends tab

https://docs.google.com/spreadsheets/d/1kGhEDiDVKsY2kS_G10e3fthJacIkR77tGcMHmm5TQFo/

Automated overview of dividend payments
Automated overview of dividend payments
Graph of dividends per month, per year
Graph of dividends per month, per year
Categories
Uncategorized

Frigate

I had a camera “front”.
I renamed it in the config to “front1” and added another camera called “front2”.
Once I was happy with my new higher resolution camera, I removed the old one and went back to just one camera in the config called “front”. I think that this caused all my recordings to disappear from disk.

However, the Frigate database seemed to think that they were still there. Deleting them all manually is somewhat tedious (especially because I had 29k of them!). So, I decided to delete them from the sqlite database with a command.

First I installed a sqlite client:

sudo apt install sqlite3

Then I worked out the date timestamp value that I needed by visiting Epoch Converter and picking the date time that I know I made a mess.

Yr Mon Day Hr Min Sec
2023- 6- 29 21 : 0 : 0 GMT
Human date to Timestamp
Epoch timestamp: 1688072400
Timestamp in milliseconds: 1688072400000
Date and time (GMT): Thursday, 29 June 2023 21:00:00
Date and time (your time zone): Thursday, 29 June 2023 22:00:00 GMT+01:00

I then copied the Timestamp in milliseconds into my delete command

$ sudo sqlite3 frigate.db
SQLite version 3.34.1 2021-01-20 14:10:07
Enter “.help” for usage hints.
sqlite> delete from event where start_time <= 1688072400; sqlite> .q

It took a few seconds, but dropped my events from 29k to 71.

Categories
Crypto

Scam video on YouTube advertising AMZ coin- PRE5RT AZM77X AZT33X ZAT44R AMA44X AMA55X XRM5T AZN66X AZN44X

Scam video on YouTube advertising AMZ coin-
There’s a video channel @CoinmarketcapEN which has 1M followers, but looks like it’s just a hijacked channel that has been rebranded to look like @CoinMarketCapOfficial.
They have 1 video, but their main page is full of playlists from the official channel, which helps to make it look legit.
Edit: New channel called “Coinmarketdaily” is doing the exact same thing

My attention was drawn to it watching financial videos and seeing comments mentioning first of these strings : , obviously they will switch to the 2nd, 3rd at some point in the future.

Edit : I’ll maintain a list of strings that they are using here:
PRE5RT AZM77X AZT33X
ZAT44R AMA44X AMA55X
XRM5T AZN66X AZN44X
AMZ2000X AZM1000X
AZW66X AZWR60
ETF1000X ETF2000X
ETF1000X ETF2000X
#ETF1000X #ETF2000X
AIZ500X AIZ300X
#AIZ500X #AIZ300X
AIZ500X$ AIZ300X$
AIZ500X$ AIZ300X$
AUT33X AWSTR6
AUT33X AWSTR6
AZMN3T AMCR7T AMCR4T
AMZK22

The current scam website where people are being directed to is :
https://amazonwallet.sale/presale
which has now been replaced with:
https://amazonwallets.co/presale/
which has now been replaced with:
https://www.amzlaunch.io/presale/

Categories
Linux

Scanning in Linux

I was having a mare trying to get scanning working on my USB HP Deskjet 2050.
Even though some of these settings are listed as defaults, it produces rubbish.

So I thought that I would document a working command!

Obviously you need to install the scan utilites
matt@server:~$ sudo apt install sane

Then list the devices:

matt@server:~$ scanimage -L device `hpaio:/usb/Deskjet_2050_J510_series?serial=XXXXXXXXXX' is a Hewlett-Packard Deskjet_2050_J510_series all-in-one

And use the output from above to specify the device:

scanimage -d "hpaio:/usb/Deskjet_2050_J510_series?serial=XXXXXXXXXX" --mode Color --resolution 200 --brightness 1000 --contrast 1000 -o scan9.jpg

Categories
Linux Security

Fail2ban not picking up sshd attacks

It wasn’t working for me, no matter what I tried.
The command
fail2ban-regex /var/log/auth.log /etc/fail2ban/filter.d/sshd.conf
was showing matches successfully.

In the end I ran these commands… I’m fairly sure it was just the RepeatedMsgReduction setting to off that fixed it though

dpkg-reconfigure tzdata
ln -s /usr/share/zoneinfo/Europe/London /etc/localtime

vim /etc/rsyslog.conf
#Change this line of "off" so we can see all messages
$RepeatedMsgReduction off

Then
service rsyslog restart

Categories
Crypto

Recovering from a wallet transfer mistake

The mistake

You sent money from Binance to another wallet, but chose the wrong network.

There are many options when transferring money around wallets and it’s quite tempting to choose the cheapest option, but that isn’t always right.  This example is where someone sent some USDT from their Binance wallet to what they thought was their USDT Wallet using the Blockchain app.  The user sent the money using Binance Smart Chain (BSC), but Blockchain.com do not support BSC.

LUCKILY, the Blockchain app allows you to view your private keys and even more luckily BSC is just a copy of ETH, so those private keys can be imported into a wallet that does support BSC.

Step 1 : Confirm you can actually recover from your mistake.

This is a lot of messing around, so make sure that you meet the recovery criteria before messing around.

You MUST meet both these conditions:

  1. You sent from Binance using BEP20 (BSC) to a ERC20 wallet.
  2. You have access to the private keys of the destination wallet (if not you might be able to raise a support request with your wallet provider).

Step 2 : Find your private key for your destination wallet

Warning: Never give your private keys to anyone.  Do not email them.  Do not store them unencrypted on the internet.

Examples of wallets where you can get to your private keys.

Blockchain Wallet (from Blockchain.com or the Blockchain app)
  •  Visit https://login.blockchain.com/ and login.
  • If you don’t know how, it’s really easy if you have a webcam on your PC/Mac, just choose “Login my mobile” and on the mobile app, use the top right menu option “Log in to Web Wallet”.
  • On the blockchain website, the far right settings icon has the option of Wallets and Addresses, pick that.
  • Click the Ethereum button
  • Click View your Private Keys.
Exodus Wallet

For Exodus wallet view this article

Step 3 : Install Metamask wallet

You can install this as a browser plug-in or Mobile app for Apple or Android

Go through the set-up procedure, secure your recovery key and maybe view the tutorial.  Note that the recovery key is only for the new wallet that Metamask creates for you when you install the app.

Step 4 : Import your private key into Metamask wallet

When viewing your wallet, click/press the circle above “Account 1” that looks like it could be a profile picture.  Choose “Import an Account” and paste your private key from Step 2 into it and then click “IMPORT”.

Step 5 : Add Binance Smart Chain network to Metamask wallet

Press/click the menu button on the top left, press Settings, scroll down and pick “Networks”, choose “Add Network” and enter the following:

Network Name: Binance Smart Chain
New RPC URL: https://bsc-dataseed.binance.org/
ChainID: 56
Symbol: BNB
Block Explorer URL: https://bscscan.com

Then click Add.

Note: To switch between Ethereum Network and Binance Smart Chain – just click the top of the app, where it says “Wallet”, you might need to scroll down to see the Binance Smart Chain.

Step 6 : Make sure Metamask is pointing the Network and Wallet

Make sure that you are now using the right Network and the imported wallet (Account 2)

Click/press the very top of the Metamask app where it says “Wallet Ethereum Main Network”.  Scroll down and choose “Binance Smart Chain”

Click the menu button on the top left and click on “Account 1” and choose “Account 2”.

Step 7 : Add your missing coin to the BSC wallet on Metamask

At the bottom of the Metamask wallet, click “+ADD TOKENS”.  Search for the token that you are missing (eg. USDT) and then click “ADD TOKEN”.

You might need to restart Metamask in order to see your balance.

Step 8 : Now get it to where you wanted it

There are a number of ways to do this, but the easiest is to send it back to Binance.  In Binance, when you look for your Deposit address, make sure that you pick BEP20 (BSC).

After you have done this, send it to the right place using the network that BOTH wallets support.

NOTE: this was quite complicated to work out, so if this helps you and you would like to send me a tip my wallets are:

BTC
1Gxjf2crehcSDRQh4dUkGD4wcg8AartTqm

ETH (ERC20 or BEP20)
0x4471e4ab83069fd926ba418a1731766b4699e313

BNB (BEP2)
bnb136ns6lfw4zs5hg4n85vdthaad7hq5m4gtkgf23
Memo: 102292475

Categories
Crypto

Step by step first dip into crypto

Warning

Only put in money that you can afford to lose completely.  Crypto currencies are relatively new and a simple legislation change could make the price halve in a matter of minutes, an exchange could be hacked, or the exchange owner might disappear with all the assets.

Step 1 – Sign up at an exchange

The below are referral links that might give me a small tip or even both of us free BTC when you get around to depositing.

Binance is the main one that I use, and it is by far the cheapest.  Customer service is hard to get hold of if you have a problem.

Coinbase is probably the easiest exchange to use, but has high fees, a poor selection of coins to invest in and the spread (difference between buying and selling) is very wide.

Kucoin is another alternative that has a diverse range of investment options.

Poloniex is a good alternative with a clean look about it.

Step 2 – Provide identification & set up 2FA

It’s all good signing up, and they might even let you deposit, but the exchange might not let you withdraw until you have provided your ID.

Ensure that you set up 2 Factor Authentication, which is usually done using the Google Authenticator application.  Make sure you write down your recovery code and keep it somewhere very safe.  What you put into your account now might seem like not much, but in 5 years you might be crying if you cannot login.

Step 3 – Deposit using card or Faster Payments

It might be tempting to just go for the easy option of buying crypto with a card, but this simple option comes with a 2% fee.

A Faster Payments deposit is free, perhaps send a smaller amount on your first transfer, and then a spot trade has 0.1% fee.

Step 4 – Use 50% of your deposit  to buy the crypto that you are interested in

On the Binance menu, choose Trade > Convert, pick GBP from the top one, use half of what you have put in.  Not putting all your eggs in one basket is a good idea.  That goes for Exchanges too.

Step 5 – HODL (Hold On for Dear Life)

Waiting can yield some impressive gains, so do it.

Step 6 – BTD (Buy The Dip).

Warning: If it is just your coin that is plummeting you need to question whether this is a dip or a bad investment.

When there is a large dip, it’s time to spend some of that money that you have been holding back.  Use 10% of what you have left every time there’s a strong dip.  If it keeps going down, wait a week and buy some more!  If you run out of money, you are back to step 5.

My Investing

I have about 50% Bitcoin (BTC), 25% Ethereum (ETH) and then lots of other “gambles” on smaller coins either because I like the prospects, or because there is a current buzz (but get out quick on these).

On my smaller coins, I tend to sell 50% of a coin when the price doubles.  I like having the feeling that I’ve effectively got them for free.

After 1 month of my initial investment I was more than 50% down.  This lasted a long time and I stopped looking at it.  2 years later my investment was 2x.  Another year and it was over 5x (before the crash in 2017).  In Feb 2021, I withdrew 3x what I had invested over the years and still have well over 10x what I invested.  

Resources

https://coinmarketcap.com/ – the best resource for coin information.

https://www.cryptocompare.com/ – a good resource for coin information.

https://www.blockchaincenter.net/bitcoin-rainbow-chart/ – Bitcoin rainbow price chart.

https://alternative.me/crypto/fear-and-greed-index/ – Crypto fear and greed index.

Categories
Crypto

How to withdraw from Binance

A crypto currency investment can make you a lot of money very quickly, but it isn’t much good if you cannot convert into hard cash.

I have recently seen a post on Martin Lewis’s Facebook page and there were comments about people not knowing how to withdraw their investment.  So, here is an easy, step by step guide for Binance.

Binance

Log into the Binance website (not the mobile app).
Step 1 – Convert your Crypto currency into GBP
The first thing you need to do is to convert whatever crypto currency that you want to withdraw into GBP.
The easiest way to do this is to choose the option from the top Trade->Convert.  Choose BTC in the top box, GBP in the bottom box and then click the “MAX” option and you can then preview your sale before confirming it.  If this works for you, jump to Step 2.
Depending on which crypto currency you own, you might not be able to do this.  You need to swap it for GBP, but Binance might not support that market pair.  So you might need to swap to an intermediary currency first (BTC and BNB is swappable with most currencies)
To swap one currency for another – this example is BTC to GBP.
  1.  Choose Trade -> Classic
  2. On the upper right there is a search box, enter BTCGBP and it will show BTC/GBP under it – click that.
  3. Scroll down to where it shows Buy BTC and Sell BTC.  You want to Sell BTC for GBP, so you will be using the right side boxes.
  4. Just above the boxes, but to the left of the screen, there are options for “Limit”, “Market” and “Stop-Limit”. Using the “Market” rate simplifies the process and means you will get a sale now.  If you want an idea of how much you might get, try using the “Limit” option first and it will tell you.  You can then switch back to “Market”.  If you click sell when you have chosen “Limit”, you might create an order that is trying to sell at more than the market is willing to buy at, which might not get filled.  If this happens your currency is “locked” until you release the trade by cancelling it.
  5. After you have chosen “Market”, in the Sell section on the right, there is a bar with blobs on it which lets you easily select how much you want to sell.  So click one of the blobs and adjust it to how much you want to sell.
  6. Click the red Sell Button and some some boxes will flash up the screen saying “Order Created” and “Order Filled”.
  7. Click the “Trade History” option that is a bit lower on the screen and you will see how much you got and what fee you paid.
  8. Click on Wallet -> Fiat and Spot to see how much you now have in your GBP wallet.
Step 2 – Withdraw your GBP
  1. Click Wallet -> Fiat and Spot
  2. Under the GBP asset, click the Withdraw link.
  3. Choose which ever option is cheaper – Faster Payments £1.50 fee, or payment to card at 1% fee.
  4. If you want to withdraw it all, just click on the number what it says is available and it will fill it in for you.
  5. Continue…
Categories
Crypto

How to withdraw from Coinbase

A crypto currency investment can make you a lot of money very quickly, but it isn’t much good if you cannot convert into hard cash.

I have recently seen a post on Martin Lewis’s Facebook page and there were comments about people not knowing how to withdraw their investment.  So, here is an easy, step by step guide for Coinbase.

Coinbase

Log into the Coinbase website (not the mobile app).
Step 1 – Convert your Crypto currency into GBP
The first thing you need to do is to convert whatever crypto currency that you want to withdraw into GBP.
  1. Click Portfolio, select the currency.  On this screen you are looking at the contents of your “wallet” you can only add/remove funds in that currency.  eg. sending money from your BTC Wallet on Coinbase to your BTC Wallet on Binance
  2. Click Overview. Now you can see Buy/Sell options.  This allows you to swap one currency for another.
  3. Choose the Sell option for your currency, depositing to your GBP wallet.
Step 2 – Withdraw your GBP
  1. Click Portfolio
  2. Select the GBP asset
  3. Choose withdraw
  4. Withdraw all
  5. Continue…