Tracking prices

[VonMedo]

Is there any way I can track prices of items everyday w/o looking up every one on GE?

I have a drop tab and would like a program that tracks value of my tab and tells me if I lost or gained money from GE update.

 

I think I saw that somewhere but not sure...

[Lord Paul]

I don't know of any generic calculator offhand, but it would pretty easy to do a personalized one in Google Docs for ya.

[Ambler]

You could just use the price checker every day, but not sure on anything that auto-calcs prices for you... :-k

[Hedgehog]

I don't know of any generic calculator offhand, but it would pretty easy to do a personalized one in Google Docs for ya.

The problem is that google docs automatically updates, so you can't really track it. I could think of a couple of solutions, though.

[Lord Paul]

Yeah, just write down the sum every day and graph it, but that's not automated. Easy enough to do, though.

[VonMedo]

if someone could make automated one for me that would be awesome...

 

but I know i saw it somewhere,from guy named tlin or something

 

 

EDIT:

 

http://abstract.cs.washington.edu/~tlin/rsc/layout/nwt.png

 

found image,can't find actual program

[Hedgehog]

Give me a list of items you need to track and I'll see what I can do.

[Lord Paul]

Shoot me a link to it. I'm interested in it as well.

 

My code may not be efficient, but it still works. :P

[VonMedo]

Just all waterfiends drops,I have drop tab for them on my way to 96 summon and want to keep track of it's worth

 

water orb

rune med

water talisman

water battlestaff

seaweed

snape grass

death rune

blood rune

watermelon seeds

mithril arrows

ranarr seed

 

 

It's a longer list,but if you can make google docs remember prices just make it for 1 item and I'll add the rest :)

[Lord Paul]

Since it's 4AM, I've only allowed Meredith to edit it (I think so at least). If you have a gmail account, pm it to me and I'll add you to the list of people that can access it.

 

It's a starting point at least. *shrugs*

 

Waterfiends PC

 

Edit: Searched their drop table and added some of their more valuable drops.

Edited April 24, 2012 by Lord Paul

[VonMedo]

Since it's 4AM, I've only allowed Meredith to edit it (I think so at least). If you have a gmail account, pm it to me and I'll add you to the list of people that can access it.

 

It's a starting point at least. *shrugs*

 

Waterfiends PC

 

Edit: Searched their drop table and added some of their more valuable drops.

 

 

thanks a lot,copied it to my own sheet,22m drop tab from wfs so far =)

 

only 1 more thing,I can calculate with -20 but I can't do anything with +20,how to remove that +?

 

nvm did it

[Hedgehog]

https://docs.google.com/spreadsheet/ccc?key=0AheuzHmAkHUNdDlnMDhYQ2lHZVBQdW5QWTFhVDNQblE

 

Edit your quantities with this spreadsheet. You'll need to pm me your gmail name first, though.

 

Then, run this ahk script:

 

#Persistent

Menu, tray, add, Get current value, getcrntval

Loop
{
FileDelete, WFSGEDATA.txt
URLDownloadToFile, https://docs.google.com/spreadsheet/pub?key=0AheuzHmAkHUNdDlnMDhYQ2lHZVBQdW5QWTFhVDNQblE&single=true&gid=1&output=txt, WFSGEDATA.txt
FileReadLine, Drop_Sum, WFSGEDATA.txt, 1
StringReplace, Drop_Sum, Drop_Sum, %A_Tab%,,All
FileAppend, %Drop_Sum%|, WFSTemp.txt
FileRead, WFSData, WFSTemp.txt
StringSplit, WFSData, WFSData, |
Max := WFSData0 - 1
2nd := Max - 1
Max := WFSData%Max%
2nd := WFSData%2nd%

if (Max > 2nd)
{
delta := "increased"
}
if (Max < 2nd)
{
delta := "decreased"
}
if (Max = 2nd)
{
delta := "remained the same"
}

TrayTip,WFS Drop Tracker,The price of your drop tab has %delta% since the last check.,15,1
Sleep, 900000
}
return

getcrntval:
MsgBox, %Max%

[Lord Paul]

Damn, that's an impressive AHK script. :o

 

Is it just copying each day's total sum into a .txt then checking the current value against the last line? Very cool.

[Hedgehog]

It checks every 15 minutes. Then it compares the value to the previous value and returns whether it increases, decreases, or stays the same. You can how often it checks by editing the number after Sleep (in milliseconds). You can also check the current price by right clicking the tray menu.

[VonMedo]

wow,you guys really did great job,thanks a lot,I have it in my own spredsheet now thanks a lot

[Hedgehog]

The script will only work if you use the spreadsheet I made.

[VonMedo]

I know,because of the URL ;)

 

The spredsheet alone was enoguh,thanks a lot

 

you guys should do bank worth tracker for tip.it site,would be awesome to have it in calculators,idk if it will take up too many resources but would be nice to have it

 

once again,thanks a lot =)