| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
quikfingrs
Salamander Researches And Industries
1
   |
Posted - 2014.12.24 09:52:07 -
[1] - Quote
Argonicus wrote:I try to use your script. Link to google docs open, but script doesn't work.
I'm copy script text, create new script in my google scripts, but if i add function =loadPrices, i got message #Name
Who can helps me with this?
have a gander at the top of steve scirpt and see this part
=loadPrices(A4:A92, 10000002) thats mine his is similer :) jus tneed to read the small print :)
by the way steve is that script of ure able to pull station data or system data other than region? |
quikfingrs
Salamander Researches And Industries
1
|
Posted - 2014.12.24 22:31:01 -
[2] - Quote
Steve Ronuken wrote:quikfingrs wrote:Argonicus wrote:I try to use your script. Link to google docs open, but script doesn't work.
I'm copy script text, create new script in my google scripts, but if i add function =loadPrices, i got message #Name
Who can helps me with this? have a gander at the top of steve scirpt and see this part =loadPrices(A4:A92, 10000002) thats mine his is similer :) jus tneed to read the small print :) by the way steve is that script of ure able to pull station data or system data other than region? It's currently set just for region. But that's just due to the url that's being used. you could change it easily enough.
i take it ure talking about line 26 ,13, 15?
i havent really go ta clue about code but wha ti have tryd doesnt work how would i edit it to pull jita 4-4 or jita only? |
quikfingrs
Salamander Researches And Industries
1
|
Posted - 2014.12.25 11:24:14 -
[3] - Quote
yeh the majority of the market is good for jita region wide but some things ar emuch cheaper in the region else where from jita so it can muddle up the correct prices slightly,
that would be nice but tbh id like to understand the code a little aswell to be able to do similer stuf my self if the future :) hate being one of these can u do this for me attitude :), |
quikfingrs
Salamander Researches And Industries
1
|
Posted - 2014.12.26 19:58:40 -
[4] - Quote
Steve Ronuken wrote:quikfingrs wrote:Steve Ronuken wrote:quikfingrs wrote:Argonicus wrote:I try to use your script. Link to google docs open, but script doesn't work.
I'm copy script text, create new script in my google scripts, but if i add function =loadPrices, i got message #Name
Who can helps me with this? have a gander at the top of steve scirpt and see this part =loadPrices(A4:A92, 10000002) thats mine his is similer :) jus tneed to read the small print :) by the way steve is that script of ure able to pull station data or system data other than region? It's currently set just for region. But that's just due to the url that's being used. you could change it easily enough. i take it ure talking about line 26 ,13, 15? i havent really go ta clue about code but wha ti have tryd doesnt work how would i edit it to pull jita 4-4 or jita only? on line 37, the url to pull from evecentral is specified.
var url="http://api.eve-central.com/api/marketstat?cachebuster="+cachebuster+"®ionlimit="+regionID+"&typeid=";
if you were to change it to
var url="http://api.eve-central.com/api/marketstat?cachebuster="+cachebuster+"&usesystem="+regionID+"&typeid=";
you could then restrict it to Jita, by passing in jita's systemid (30000142). of course, it's less than ideal, if you don't go and rename all the regionID to systemID but it should work. (copying the function and renaming it might be wise. just so you can still get region level pricing)
Yeh it took me a day to iorn it out but got there in the end but that's exactly what I did including editing all regionid to system id and usesystem, but thanks for the info =ƒÿÇ everyday a learning day lol
I did hit the same thing mentiond about exceeding the url length though lol was going to make a second sheet till I seen the bottom post, but had two ideas if I used the link info above about chunks where would I put that Comand line in ure sheet would it be after the eve central api function ?
The other thing was groupid's does that pull all data of the group and give you all the info of all items in that group or am I reading it wrong ? Cos if it did I could change itemid to groupid's and that would slash the app pull of all 159 items I need by a hell of a lot |
quikfingrs
Salamander Researches And Industries
1
|
Posted - 2015.01.05 14:27:19 -
[5] - Quote
im not sure if it is me or a slightly modified version of your script but,
when i used to do the api pull from eve central it would automatically update my sheet on the fly ( think hourly or 30mins ) with new prices and would pretty much be bob on,
since ive been using your script ive noticed that it doesn't update my script for over 2hrs at a time and some ive sat and watched for close on a hr nothing came back a hr after that and still nothing, so unsure the time interval of when it does update but im pretty sure it does update at some point in 24hrs lol,
i made a separate sheet and uploaded your new script and the first load of prices i compared them to eve-central and they were 2hrs out so its defiantly around the 2hr+ marker
i have set my triggers for the script for time driven 1hr also even set it to 15min just to see and nothing changes,
so is this how it is or has something gone pete tonge my end lol |
| |
|