Hi, I am trying to do this as a calculation in Google Sheets, using live JSON data, pulled directly from the Splinterlands API. However, I cannot find any API endpoints which contain the BCX
and CP
values themselves. I guess this means that I will need to feed my spreadsheet an algorithm for calculating these values on-the-fly, from the information you have provided in your post here. I can already get the Foil
, Edition
, and Rarity
for a given card, direct from the API. Some problems that I am still facing on this include...
❶ How to determine whether or not a BETA card has been converted from an ALPHA card, or not?
❷ How to determine the card border type of the REWARD cards?
Once I have those two factors determined, then I should be able to write an algorithm in Google Sheets to claculate the BCX
and the CP
values for each card in my collection. Does that sound about right? Thank you for any help you can offer with this.