What is your version of excel ?
i, using excel 365 it only works in that version
I do have some issues with the MARKET_ORDERS_STREAMING, as its not pulling the right amounts of orders that i clearly see in-game in that specific. its only showing 1/4 of the orders it should’ve pulled.
Tested this is my own sheet, and in the example sheet provided with a market function.
When i finally got it to do what i wanted, i crosschecked it and saw that it didnt manage to pull all, or the correct data…
It ommits (private only?) stations with a single order for a given region id and type id. I am not sure if it only has an issue with Sell or both Sell/Buy orders.
I only pinpointed stations with single Sell order for few type ids. Can you confirm this with your data?
When u mentioned private only you were on point hehe.
Its from a 0.0 market hub, but not for public i guess. So the orders i got were buy orders set with a range from that structure…
Currently with the Character assets we can only do a text search, which can lead to more results (f.e. Platinum yields Platinum, Platinum Technite, Platinum Techinite Reaction Formula etc). Don’t know if this is the right place for feedback on the addin, but it would be great if we can have either a parameter for an exact match (like inventory search) or if we can search by ID instead.
1 Like
Is it confirmed that this is not accurate and the only working Windows version requires the Office 365 sub?
Strict is being added to all searchstring filters for next patch. Just an oversight on my part not to include that option.
2 Likes
/markets/structures/{structure_id}/
When we implement this endpoint you’ll get the capabilities to get private structure orders, it’s just not as user friendly as the public endpoint.
Will require the structure_id and a signed in character (and if you have multiple characters you’ll need to specify what character’s tokens to use to check for access)
1 Like
Yeah, those were the requirements for CustomFunctionsApi(can’t remember exact name).
When it should have been a combination of that API and ExcelApi 1.16+
We updated ExcelApi requirements for the add-in store to the correct one, in version 1.1.
After that update the store tells us for desktop windows is just compatible with M365.
The add-in (in v1.1) does a client-side check for that Api version and displays an error instead of the character login about the Api missing that all functions require.
here is the compatibility list of the ExcelApi:
1 Like
glad there is finaly some clarity on compatibility, and great to see ms and CCP havent changed, needing a subscription on the most used platform to use an addon for excel.
GG
This addon now has been proven to be what it looked like at launch DOA
Understood, thank you.
The web version crashes the excel browser tab after a few minutes.
The details are:
Eve is now even less fun and more like a full-time job.
You have been briefed.
1 Like
The spreadsheets had always been a part of making bank in New Eden.
Or even working out the number of Cats required to arrest a Criminal Miner!
1 Like
Most likely using a function like ASSETS call that’s forever #BUSY looping, or couple of the functions that can return data exceeding the web payload limits.
If you are using the example sheet and login a character with enough items that can hit that web limit it’s highly likely it’ll crash very fast as the example sheet is already heavy.
Character_Assets in version 1.1 had included an optional parameter for paging that can help with this issue on web excel, alongside searchstring and location_id filters.
There are other functions such as inventorysearch, searchsolarsystems and char/corp _transactions that can hit these limits afaik with empty searchstrings for the first 2 and with a very active wallet in the _transactions call.
(Below is the character_assets section from function.json that excel uses for the fx help segments in desktop.)
{
“description”: “Get assets for a character”,
“id”: “CHARACTER_ASSETS”,
“name”: “CHARACTER_ASSETS”,
“parameters”: [
{
“description”: “The character id or entity. If omitted, assets for all signed in characters will be returned”,
“name”: “character_id_or_entity”,
“optional”: true,
“type”: “any”
},
{
“description”: “String to filter out results by”,
“name”: “search_string”,
“optional”: true,
“type”: “string”
},
{
“description”: “String to filter out results by”,
“name”: “location_filter”,
“optional”: true,
“type”: “number”
},
{
“description”: “Page of results to display (1000 per page)”,
“name”: “page”,
“optional”: true,
“type”: “number”
}
],
I’m a little opposite. I ran the Assets for one toon and it came back quick with 2 rifters. I have a ton of manufacturing stuff that never pulled.
Also - is there an ‘official’ help desk for this or is it this forum?
The Assets formula picked from the Functions menu right to your character portrait has added “Rifter” search string by default:
=EVEONLINE.CHARACTER_ASSETS(2115458989,"Rifter")
Try removing it but simultaneously add location id parameter (or empty) or page number and then you should get other assets listed.
The official help page is here:
1 Like
Thank you! And I thought the learning curve for EVE was steep!
1 Like
I’ll be trying to create a helper docs site with the functions, more detailed explanations and their parameters for filtering if there are any applicable, Excel web for example doesn’t really expose the parameters nicely for the user so helper parameters get hidden there.
Hopefully we can collate some example functions from users to that docs site as well to help those not used to more advanced excel functions what works with the add-in data since it’s a new format to excel, i.e. the “entity cards”
3 Likes