[Julian]

Impressive !
A fine example of the inflation of the standard of living, but at a level that borders on the ridiculous. It reminds us that wealth is not the goal, only a means to facilitate living fully.

However, you still have to figure out what living fully means for you first... Not as easy as it seems 🙂

[Julian]

I made the same choice, Degiro + IB (I went to IB after seeing that it was complicated to find choice in international micro caps).

Satisfied with both for now, although I'm still having a bit of trouble getting to grips with the IB interface.
Also, the minimum purchase volumes are sometimes too high for my small wallet.

[Julian]

Hello

 

@PloutosNX, I gave you access, you will tell me what you think 😉

 

@Jérome, yes it's true that it's already a big step to put a few % of your wallet in Bitcoin! Going further is for me analogous to buying physical gold, versus an ETF.

It's simpler and more economical (at least for gold) to have an ETF, but we have the counterparty risk. With physical, we are outside the system and I find that it makes sense in terms of diversification.

There is also a story of believing in the crypto model and bitcoin, which is not uninteresting either.

But you've already done the hardest part, putting your foot in it!
A+

[Julian]

Thank you Jerome,

For ABTC, I had selected it for my trend following. I considered it as an investment, before finally returning to direct purchase.
ABTC has the advantage for me of being 100% physical, they buy as much bitcoin as is invested. For XBTE, they indicate a synthetic replication, I'm not sure how they do it.

On the other hand, ABTC is relatively new and does not have a lot of volume/day. I don't know if this is a disadvantage or not!

I went back to direct purchasing, to reduce fees and (paradoxically) increase security. By storing crypto off-network there is no risk. Cryptocurrency exchanges are regularly hacked, I am more relaxed like that. Even if you sweat a few drops at the beginning to transfer a large amount to your personal wallet in btc!

[Julian]

Okay let's do this
I'm sharing with you a watered-down version of my Google Sheet (randomized values on the number of shares and available cash, and a few fewer personal sheets)

https://docs.google.com/spreadsheets/d/1ucTd4e8sQO8NDMgTMHzQO2z3VmhTyNEISWz5l121l6U/edit?usp=sharing

The first tab serves as a summary, for the valuation of stock market, precious metals and cryptocurrencies portfolios (others can be added).
It is also used to group together different indicators, such as US unemployment, which is calculated in the dedicated sheet. US unemployment is automatically retrieved from the US Department of Labor website, and I added an estimator of the future monthly value with the claims, which are released weekly.

In this first sheet, there is also a monitoring of the volatility of a certain number of target values, I was inspired by the values followed in the determining portfolio. I calculate the volatility at 60 days annualized, for the current day, the previous month, and so on up to 3 months back. With google finance we have free access to the values, and therefore it is always up to date.

In the second sheet, it is a follow-up of the stock portfolio, in which we add its values, the PRU and the purchase date. We have some graphs and metrics that are automatically generated. However, there is no way to track dividends, it must be done manually.

 

For the precious metals and cryptocurrencies pages, I use other data sources, for the moment it works correctly, but it risks being less reliable than Google finances in the long term.

I hope it's more or less clear with the file access :)

[Julian]

Hi,

It is possible to automate the updating of volatilities and values in a Google Sheet, because it can have access to different online data sources. In particular, Google Finance is able to follow almost any listed value (with the difficulty of finding the right code sometimes...)

We don't have access to detailed financial data, but to calculate volatility or momentum it works perfectly.

If you're interested I can make you a shared version and we can work on it together (I worked hard on mine but I'm trying to improve it every day!)

See you soon

[Julian]

Yes cryptos, what madness!

I regret not having entered it earlier, I had been interested in it in 2016, but it was still quite confidential and not very secure. Today it is much easier even if you always have to be careful about security.

I saw indeed that you added a line and started investing in XBT. Are you buying directly or via an ETN?

see you soon

[Author]

Posts