These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

Market Discussions

 
  • Topic is locked indefinitely.
 

Sheet Prices not updating

Author
Bengo
The Scope
Gallente Federation
#1 - 2015-11-02 00:21:21 UTC
One good thing about playing Eve is its forcing me to learn how to use spreadsheets which is something I've wanted to do for a while. I am trying to make a spreadsheet for PI and Reaction pricing and I am using fuzzworks script ( https://github.com/fuzzysteve/eve-googledocs-script/blob/master/EveCentralPrices.gs ) in google sheets. I got everything to call correctly and load into the page but now I am noticing that prices arent updating. I tested on two sheets this week and if I open them both right now one Data Chips Jita Buy at 65k each and the other them at 67k while in Jita its 70k.

If i delete and readd =loadSystemPrices(B3:B85) it will load the correct values and everything is fine but it doesnt stay updated after a couple days. Is there a way to force it to update on the fly?
Professor Humbert
Project Fruit House
#2 - 2015-11-02 09:10:25 UTC  |  Edited by: Professor Humbert
Bengo wrote:
One good thing about playing Eve is its forcing me to learn how to use spreadsheets which is something I've wanted to do for a while. I am trying to make a spreadsheet for PI and Reaction pricing and I am using fuzzworks script ( https://github.com/fuzzysteve/eve-googledocs-script/blob/master/EveCentralPrices.gs ) in google sheets. I got everything to call correctly and load into the page but now I am noticing that prices arent updating. I tested on two sheets this week and if I open them both right now one Data Chips Jita Buy at 65k each and the other them at 67k while in Jita its 70k.

If i delete and readd =loadSystemPrices(B3:B85) it will load the correct values and everything is fine but it doesnt stay updated after a couple days. Is there a way to force it to update on the fly?


Have you tried changing the cachebuster parameter?

loadSystemPrices(priceIDs,systemID,cachebuster)

If you read through the script you will note that the function has in fact 3 parameters. If you just define the priceIDs and no definition for the other two like you did with loadSystemPrices(B3:B85) , the script falls back to default parameters: Jita and cachebuster 1

Apparently, changing the cachebuster parameter lets the script to fetch data directly from the Central, not from Google cache....or so I understood.
Mikha'el Airuta
Catiz is NOT my empress
#3 - 2015-11-02 12:34:28 UTC
I've had similar problem with my sheets and changing the cachebuster parameter from 1 to 2 has fixed it! Now all is working again. Hope it will work tomorrow too.

Professor Humbert for the president!!! Thank you!
Wayn Ker
Native Freshfood
Minmatar Republic
#4 - 2015-11-02 20:52:15 UTC
I read through the script and saw the cachebuster parameter defaulted to 1 and figured that was the lowest/quickest to update. I will give it a go in changing it. Thanks for the push in the right direction.
Professor Humbert
Project Fruit House
#5 - 2015-11-03 02:59:52 UTC  |  Edited by: Professor Humbert
Wayn Ker wrote:
I read through the script and saw the cachebuster parameter defaulted to 1 and figured that was the lowest/quickest to update. I will give it a go in changing it. Thanks for the push in the right direction.


Instead of changing the default value in the script, you can call the function from the sheet like this

= loadSystemPrices(B3:B85, 30000142, A1)

and change the value in the cell A1 whenever you suspect the prices are not being updated.
Gadolf Agalder
Sebiestor Tribe
Minmatar Republic
#6 - 2015-11-03 06:33:33 UTC
I used to make databases with integrated display scheme such as spreasheets for accounting amongst other things.
Lotus 1 * 2 * 3 was a commercial program developed then with a WYSIWYG interface.
I don't need the 3rd party license but I still have the 5.25 inch floppy.