Market Data

Need help with market data. While creating market data for local system i noticed that many products that are on the market are not visible in spreadsheet.
Example:
=EVEONLINE.MARKET_ORDERS_STATS(10000009, 36, 1049588174021).sell.min
There is Mexallon on the market but spreedsheet with used function do not give any result.
Function works perfecly when used on JITA market but have issues in Insmothere region.

Maybe an issue with the player structure?

What if the structure does not have public access, but does have a market for its Corp members?

At first i thought that might be an issue.
To be sure i run GESI script on google spreadsheet with same account on the same structure. It worked perfectly with region and structure data.

Second thing i did was running formula
=EVEONLINE.MARKET_STRUCTURE_ORDERS(1049588174021, 37, FALSE)
and recived full data.

Last thing is that formula =EVEONLINE.MARKET_ORDERS_STATS(10000009, 37, 1049588174021).buy.max work on some items, but it looks like EVEONLINE.MARKET_ORDERS_STATS formula cant get up to date data form player station.


EVEONLINE.MARKET_ORDERS_STATS function

Added how EVEONLINE.MARKET_STRUCTURE_ORDERS works on same station.

Strange, I’ll try to reproduce this on a structure.

Structure market is a single list of all the orders, irregardless of type_id, that is sorted afterwards. So maybe it missed a page in the stats field creation, but re-fetched when the non-stats was run.

Since the _STATS should use the same cache as the raw market_structure_orders does.