📈 How To Crunch The Numbers Behind NFTs

Understand how to use my NFT market analysis spreadsheets

Hi there!

I’ve been doing NFT market analysis for more than half a year now but never wrote an introduction to the metrics I use. I sporadically tweet about those indicators and their meaning, but they get lost over time. This article will teach you how to use them.

Let’s start with the spreadsheet link. I’m using the 100+ floor collections from the Tezos FxHash platform.

FxHash Market Analysis Spreadsheet Example. Can be used for other marketplaces.

Floor: the floor is the lowest price available in the market for a particular NFT in a collection. This term is widely used, so you better get used to hearing it.

Why is the floor used as the main metric? here are a few reasons:

1. Easiest to remember over time. If you know the floor is 10 Tezos today, you could come back in a month and see it over 50 and immediately grasp the collection’s evolution. Instead, if you used other metrics like the median cost of the NFTs in a collection, the changes are not so easy to grasp.
2. You don’t need to understand the rarities and specific dynamics in a collection this way. By using the floor, you always know the minimum you can get (if there is liquidity, which I’ll cover later). Don’t get me wrong, taking the time to learn the…