Market Discussions

Hello,

I've seen many people making EVE-Central api calls for EACH ROW of their imported asset API imports.

This is a bad practice bacause
a) unnecessary loads for EVE-Central
b) you have a limited number of fetch per day for your Google spreadsheet, which will run out very quickly

Here's how you can minimise API calls to make everyone happy.

1. Import your asset list as usual on a sheet (let's call it CorpAsset)

2. Make a new sheet (let's call it PriceSort)

3. On your PriceSort sheet, do this

=unique(SORT(QUERY(CorpAsset!datarange,"select typeIDcolumn where flagcolumn='flag'",0),1,TRUE))

EXAMPLE : =unique(SORT(QUERY(CorpAsset!C:E,"select C where E='62'",0),1,TRUE))

This will fill a column with a list of typeID's without any duplicates.
Notice that the above example is for the items in Corp Delivery Hangar.
If you want to to the entire items regardless of flag:

=unique(SORT(CorpAsset!typeIDcolumn,1,TRUE))

EXAMPLE =unique(SORT(CorpAsset!C:C,1,TRUE))

4. Do your EVE-Central price import in the next column.

5. use VLOOKUP() on the asset list sheet to populate the column with the above item prices (don't forget to multiply the VLOOKUP() result by item quantity)