New Bitcoin Bot

[Graybeard]

I started a Bitcoin Bot
I wrote the first code last night to stealth scrape a website (unnamed) at random time intervals for the price.

Random delay for cron.daily, cron.weekly, cron.monthly – trick77.com

trick77.com

Here's the 'right way' cron every 5 min then random timed

# m h  dom mon dow   command
*/5 * * * * sleep `numrandom /0..10/`m ; (cd /home/user/path/path/GBTC_BTC;./bitcoin_script.sh)  > /dev/null 2>&1

result (the date time is AM/PM) to match the GBTC stock file from my broker by the AM/PM time values.

The last column is the 'theoretical or control' GBTC price 0.0008355

The objective is to trend the GBTC
and see if the dog is wagging the tail or the tail is wagging the dog
or --how is Bitcoin (or GBTC) being manipulated and possibly the why motivations?

tail -n1  $FILE|awk 'BEGIN {FS=OFS=","} {print  $1*0.0008355}' >>$FILE

this the rough chart I got overnight in about 8 hrs~
looks like BTC leaped off a cliff (again)

Won't be able to compare the BTC/GBTC price ratios until the market is open next week ...

 

[PureLander]

Mmhm .. Bitcoin trading bot ..
I read the whole thread and stared at it for a while .. and still find it confusing

View attachment 20497

- Samira

 

[Graybeard]

the ups have it? need to wait a few hours to tell if this is valid or all bullshit

 

[Graybeard]

Well, it's decidedly flat now --hasn't hit 47,000 illogical BTC

Anyway, this is long from finished.

 

[Graybeard]

it hit 47,000+ right after I posted the above Partial vindication

 

[Graybeard]

How much difference a new day makes

Buy which dip? My robot works 24/7

 

[Graybeard]

Banged my head against the desk all day

• Now I have 2 files from different sources with the epoch timestamp being the match
• to join the tables to develop the algorithm that may (or may not ) work
• to predict the movement ratios between BTC and the GBTC stock trust.

The goal here is to pick the brains of the many traders of GBTC and their reaction to the movements of Bitcoin.

My hypothesis is the assumption that there are no underlying fundamentals and the gobly-goop of the digital currency sites is all smoke and mirrors.
But people are buying and selling for some reason and there is money to be made in their actions, irrational as they may be

This will take a few weeks to build out enough data. Unlike CPA --the data is free and the GBTC part is 100% accurate from the stock exchange. The Bitcoin part can be manipulated as f-k --it doesn't matter really
--it is the emotional trigger of the traders that their tactics are based on.

^my scrape

NASDAQ Pink Sheet SEC requlated data
epoch,timestamp,open,high,low,close,volume <by the minute by the trading day 9:30 AM (09:30) to 4:00 PM (16:00)

 

[Graybeard]

Well OK ...

Last night's chart (flat area is a website error --scraping has its own issues you cannot resolve )

Stock market closed down:

Note the down point at yesterday's stock market close --seems news driven --again nothing to do with fundementals (that are all smoke and mirrors IMO)

 

[Graybeard]

Well close --need more data points
Panic in Bitcoinland

 

[Graybeard]

How today began and ended...

and this evening R2 =1.000 is dead on. Nearest value to 1.000 wins (but not hardly absolute)

Real world; Stock markets down in US and Europe again . Delta COVID Variant rages. 1,000 dead in the US yesterday in the pandemic.

US markets are particularly bad:

I expect from these charts to see a price range between the polynomial and Log fit trend lines; up slightly tomorrow morning --but who knows --this is not exactly rocket science

 

[Graybeard]

What happens when you are developing any program --bad planning
Either that or you procrastinate for months or years to consider every possible path to glory ...
I do and fix and ladder the stuff that works --because as you go --you see opportunities to fix or improve always.
To that end:

#!/bin/bash 
#-vx
#/home/barry/path/path-path/GBTC_BTC/fix_format.sh
#  ./fix_format.sh
################################################################
FILE=btcpricetimeFix.csv
cat $FILE | while read line
do

TIMESTAMP=$(echo $line|cut -d, -f2)
FORMAT=$(echo `date -d  "$TIMESTAMP" "+%s"`)
MODLINE=$(echo $line |awk -v awkvar=$FORMAT 'BEGIN {FS=OFS=","} {print  $1,awkvar,$2,$3}' )

echo $MODLINE >>bitbotFix.csv
#sleep 1.5
done

The bash (sh) script makes this:
47549.332,2021-08-13 10:15:00 PM,39.7275
into this added (inserted with that awk code) column (in a new file)
47549.332,1628907300,2021-08-13 10:15:00 PM,39.7275

1628907300 the epoch (seconds from 1970-01-01 [the epoch of the first computer]) timestamp that is needed to normalize the 2 data files to be loaded into my database.GBTC and database.BTC --that number is the JOIN (or index) between the 2 tables to develop an aglorithm that MAY work -->> TBD later

How Bitcoin was moving --why IDK --guess
I forgot to save the new chart date --f-k it we are prototyping anyway
should read: BTC Price 08:25 Aug 19 2021
fixed

 

[Graybeard]

Well that trend-line changed a lot so far today

 

[Graybeard]

I fixed the bot file, and made the BTC (bot) table in the database
first JOIN ON t1.epoch=t2.epoch results:

The Algorithm is in the Ratio (somewhere) -- I only have too few matching dataponts to draw any conclusion

This may seem irrelevant to CPA but this, but at its core, it is statistics, and statistics is how things are properly optimized.

 

[Graybeard]

Added more GBTC Stock Trust Data and grouped this week's ratios --counter intuitive somewhat

Need more data

The last column is the 'theoretical or control' GBTC price 0.0008355

tail -n1  $FILE|awk 'BEGIN {FS=OFS=","} {print  $1*0.0008}' >>$FILE

Yesterday as a ''best guess'' I changed my price estimate formula --seems real close --good guess --but that is a static ''control price'' TBD in the algorithm.

 

[Graybeard]

First low ball order based on the data above

WARNING WILL ROBERTSON! Pink sheet security trade (the shit may hit the fans)

Well, so far heading the wrong way welcome to wall street

Bot says:

update 14:00
BTC didn't dip _>GBTC didn't dip -> limit order timed out

Have a nice weekend

 

[Graybeard]

What are weekends for during the hot summer during a pandemic --stay cool inside and recap your data

to that end;
woke up in the middle of the night and decided to look at the bot and have a snack...
BTC to the Moon! LMAO

Well, you can see the are within the trend lines (for now) until we are not

The irrationality of the ratios between BTC and the GBTC Trust 'stonk' are perplexing. My working theory is that both the news flow and the stock market index are influencing this ratio's background noise? Time to fire up the sentometer bot and scrape the news for the positive/negatives and add a new database.table. Adding the ^RUT (Russel 2000) stock index (2000 share issuers current prices) an use that %± to adjust my bot's trade price

You can see the irrational (or look like irrational prices) in the chart above ^^^

So, I had to figure out what I wanted to see


so after a few hours of head-banging (isn't programming fun) we have the actual results > the epoch time when I reset the estimated (AVGestLastsale_BTC) column
Yea!
Now I will watch a movie ... done with this 'till Monday

*correction **the 2 ratios col1 GBTC and col2 BTC close enough for rocket scientists

 

[Graybeard]

Now let's add XLM (Stellar)

XLM/path/$ /snap/bin/curl -L  -A "(Mozilla/5.0)" "https://xxxxxxx/xxxxx/XLM-USD" >xlmpage% Total    % Received % Xferd  Average Speed   Time
    Time     Time  Current
Dload  Upload   Total   Spent    Left  Speed
100  748k    0  748k    0     0   615k      0 --:--:--  0:00:01 --:--:--  616k
XLM/path/$ sed -e 's/<[^>]*>//g' xlmpage| sed -e 's/Add to watchlist/\n**/g ' \
-e 's/As of/\n**\n\n/g' -e 's/USD\*\*/USD\n**/'|grep '^\*\*[0-9]' |sed -e 's/**//' >XLMtest

#>>returns> XLMtest = 0.367837-0.007510 (-2.00%)


XLM/path/$ cut -c1-8  XLMtest
#>>returns>
0.367837
XLM/path/$ cut -c9-17  XLMtest
#>>returns>
-0.007510

\ (line break) so you can read my spaghetti code

I like XLM because it is intended for internet payment wallets but has been volatile and is good for short term speculation maybe.

 

[Graybeard]

Is Bitcoin in a Bubble? Macro Guru Raoul Pal Says Investors Should Rethink BTC Valuation - The Daily Hodl

Macro guru Raoul Pal is arguing against the idea that Bitcoin and the crypto markets are merely in a bubble.

dailyhodl.com

Bitcoin is so full of mindless propaganda

My "chart of the day" > Time was about 14:00 1 PM didn't save right?

LOL right, just an anomaly
Expand this to years of BTC --it would only look worse. Is Guru Raoul Pal really Guru Paid Shill

**added> see what I mean?

Shorter term >

 

[Graybeard]

BTC breaks 50,000 !!!

======================================
Up and Up^ LOL until crash down time --this game is all about trading on volatility.

Rocket ship is back on it's trend course (for now)

The XLM bot-proto shows a nice 4.7% gain since late last night --better that BTC
the amount is a Lot of 1000 XLM coins

I may make a GBTC play again on the dip ...

TY for coming to my TED Talk /s

 

[Graybeard]

Game on!
taking another small stab and grab attempt at GBTC
Danger Will Robertson --Danger Will Robertson!!!

chump change really ... but this is just a trial ...

Not so sure --price is changing (@_@)

scale=4
39.87/40.50
.9844


Well, I am still under the quote a bit

**UPDATE I had to lower the bid twice now ---BTC is declining (new day same shit)

>>> price was falling too fast --look for the dip that doesn't become a total rout.

order closed (for now)