Marketcap in Crypto

Hello guys

I'm trying to add a mcap filter/exploration for crypto. (Using Amibroker 6.20.1)
The EOD data is from Yahoo (which comes from CMC) using Amiquote.
Got a separate txt (tab separated) with each symbol paired to their circulating supply as this:

Ticker FullName CircSupply
ETH-USD Ethereum 120,107,310
BNB-USD BNB 147,586,979
SOL-USD Solana 448,253,951

In the import wizard:
Col1 => Ticker
Col2 => Fullname
Col3 => Aux1
Skip the rest

Separator = TAB
Pick watchlist

Skip first: 1 lines.
Log Errors: checked
Automatically add new symbols: checked
No quotation data: checked


Apparently it imports the data without problems as we can see it in the watchlist.

But when we want to use the aux1 data in an exploration or to build the marketcap, it just shows 0.

Can you please tell me what am I doing wrong?

AddColumn(Aux1, "CircSupply" , 1);
AddColumn(Aux1 * C, "Mcap" , 1);

Aux1 IS quotation data field. Any of O, H, L, C, V, OI, Aux1, Aux2 is a quotation data field.

Aux1 as any of OHLCV, OI fields is per-quotation therefore needs a DATE.

Follow the Knowledge Base:

To import non-quotation, fundamental data you have to use fundamental data fields. Again everything is described in the guide:

https://www.amibroker.com/guide/h_fundamental.html

You could use SHARES_OUT for what you are trying to do.

1 Like