Is it a good time to buy bitcoin? Doing analysis with Power BI

Learn if now is the time to buy Bitcoin, Ethereum or any other cryptocurrency do analysis with Power BI to know.
Learn how to collect information to do the analysis of your stock and cryptocurrency by using a free tool called Power BI that will allow you to understand the trend of the market.

DISCLAIMER: I`M NOT A FINANCIAL ADVISOR IT`S AT YOUR OWN RISK I`M NOT RESPONSIBLE OF ANY MONEY YOU MAY LOSE.

Where to get data
https://coinmarketcap.com/

BTC Historical data example: https://coinmarketcap.com/currencies/bitcoin/historical-data/?start=20130429&end=20200829

Power BI Desktop
https://powerbi.microsoft.com/en-us/desktop/

Power BI Formula used to calculate the variance percentage per day:
Percentage =
VAR percOH = ((bitcoin[High]*100)/bitcoin[Close**])-100
VAR percOL = 100-((bitcoin[Low]*100)/bitcoin[Close**])
VAR percCH = ((bitcoin[High]*100)/bitcoin[Open*])-100
VAR percCL = 100-((bitcoin[Low]*100)/bitcoin[Open*])
RETURN (percOH + percOL + percCH +percCL)/4

Financial Disclaimer: I'm not a financial advisor and I can not be responsible for any money you may lose.

***** Buy me a coffee *****
https://www.buymeacoffee.com/hugosilva

***** Affiliate Products *****
All products on this list I use and recommend since quality vs price are the best also I only recommend a product that I'm satisfied with it

Studio recording gear I use:
Camera: https://amzn.to/2R4pAER
Camera Exterior: https://amzn.to/2FcdpU8
Lights: https://amzn.to/2F36LiN
Full green screen kit: https://amzn.to/3i2OH6R
Microphone: https://amzn.to/3h29rKV

Desktop gear I use:
Keyboard: https://amzn.to/2QUnjw2
Mouse: https://amzn.to/35asDny
KVM switch: https://amzn.to/3jKo0nW
Laptop holder: https://amzn.to/2ZavqZS
Arm Rest: https://amzn.to/3320trT
Wifi USB: https://amzn.to/2F6jhy0
Desktop Fans: https://amzn.to/3gZTrZF
Power supply: https://amzn.to/2FdxhG4
Memory: https://amzn.to/2Z7IiAc
SSD: https://amzn.to/3lWGUd8
Motherboard: https://amzn.to/2QXeamn
Processor: https://amzn.to/3ig8XlX
GPU: https://amzn.to/3h0p8Co
Tower: https://amzn.to/3jO7iEd

Affiliate Disclaimer: Some of these links go to affiliate links where I'll earn a small commission if you make a purchase at no additional cost to you.

Видео Is it a good time to buy bitcoin? Doing analysis with Power BI канала Hugo Silva