Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Bengo
No Refunds. SpaceMonkey's Alliance
0
|
Posted - 2015.11.02 00:21:21 -
[1] - Quote
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 Solyaris Chtonium
5
|
Posted - 2015.11.02 09:10:25 -
[2] - Quote
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
Sigin-tarag Anoikis Ronin
2313
|
Posted - 2015.11.02 12:34:28 -
[3] - Quote
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
House of the Dead Monkey SpaceMonkey's Alliance
0
|
Posted - 2015.11.02 20:52:15 -
[4] - Quote
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 Solyaris Chtonium
6
|
Posted - 2015.11.03 02:59:52 -
[5] - Quote
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.
As far as I understand, you want to make your service calls unique each session. Repeated calls to the same address will get the data from Google's stored cache, not eve-central, and thus you get outdated data. That's where cachebuster comes in.
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 manually change the value in the cell A1 whenever you suspect the prices are not being updated. I, for example, use =GOOGLEFINANCE("stocksymbol", "price") value as the cachebuster coz it's dynamic, and updates slow enough not to spam the api server every second
|
Gadolf Agalder
Republic Military School Minmatar Republic
12
|
Posted - 2015.11.03 06:33:33 -
[6] - Quote
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. |
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |