Guild Wars 2

I’m a little nervous about posting this here instead of linksville, but after seeing how many people downloaded it and contacted me about it after mentioning it in another BLTC thread . . .

Anyway, I’ve made an Excel spreadsheet that pulls TP listings from GW2 Spidy. What it does is search the TP with more functionality than any other 3rd party that I’ve seen thus far.

In addition to the same basic features, it has:

• A calculated field for Profit as a percentage of Cost
• Searching with ranges (masterwork to exotic, bid price of 25c to 1g, etc.)
• Advanced filters that will filter any field(s)
• Sorting on any field
• Hyperlinks to GW2 Spidy for every item

You can download the spreadsheet and its documentation here.

Have fun with it, and let me know what you think

(* Note if you downloaded it on 4/3/13, there was a bug that made it not work on 50% of computers. You should re-download it if you had a problem.)

I got some questions about the spreadsheet, and have posted the answers on the site. But since I doubt many of you will look at the website anytime soon, I’ll answer it here also.

If you are confused how the prices are listed out, think of them as in copper only. Here are some examples of how I did the currency:

• 10 = 10 copper
• 100 = 1 silver 00 copper
• 1000 = 10 silver 00 copper
• 10000 = 1 gold 00 silver 00 copper
• 100000 = 10 gold 00 silver 00 copper

So there is a pattern to it. The last 2 digits are always going to be copper. The 2 digits to the left of that will always be silver. Any digits to the left of that will be gold.

If anyone has any questions, feel free to contact me. I haven’t gotten very much feedback on the spreadsheet but have seen almost 1k downloads now. So if you think I could make any improvements (that wouldn’t be an entire overhaul) I might be able to do it for you.

Good luck wrecking (equalizing) theTP

As a side note, I’m really not trying to bump this repeatedly to the top. If anyone thinks I’m overstepping myself on this subforum let me know or move it over to linksville.

Beware that excel can contain macros that could be potentially dangerous to your computer.

Regards
Another Tech guy

In my opinion, this is the right forum and it doesn’t count as bumping if you’re adding information

I haven’t had a chance to look at it yet, but I appreciate you sharing it with us.

RedCobra.7693:

Beware that excel can contain macros that could be potentially dangerous to your computer.

Regards
Another Tech guy

Yes, excel files can have shady macros in them. I do promise, however, that what I wrote only does 2 things:

• Downloads data from GW2Spidy
• Organizes that data into a table based off of filters

If anyone wants to vouch for it and put some minds at ease, I would appreciate it.

And if you know VBA or VB at all, you can easily take a look at the code (it’s not the cleanest, but there are some comments to give you an idea). It’s not reading or writing anything from the local machine or sending any info to other servers.

I got around to downloading it (and scanning it!) and it’s pretty darn cool. I may have to lift your code and see if I can put it into The Big Chef Spreadsheet of Foods to get a crafting versus buy cost for my chef.

Pandemoniac.4739:

I got around to downloading it (and scanning it!) and it’s pretty darn cool. I may have to lift your code and see if I can put it into The Big Chef Spreadsheet of Foods to get a crafting versus buy cost for my chef.

Yeah man, go ahead.

Sorry the code isn’t cleaner. When I initially made it for myself, I wasn’t thinking of when I would share it. So if you can sort through the semi-spaghetti code, go right ahead

just wanted to redeem myself from my post that appeared nasty, (didnt mean it to come out that way) ive checked this over and its great, no problems with this i can vouch

I love you, please have my child!
I am rich and I am going to be richer now, spending even less time <3.

Hehe, no problem RedCobra. I didn’t see it as nasty at all – just something that people probably needed to know. At least now there are a few people vouching for it. Thanks

And I’m a dude Zumy, can’t have children :p

I have successfully made1g using this program so far! which since I only invested 10g is a nice profit of 10%. Makes it very easy and not very time consuming.

ZudetGambeous.9573:

I have successfully made1g using this program so far! which since I only invested 10g is a nice profit of 10%. Makes it very easy and not very time consuming.

I’m glad to hear that . It does duplicate a lot of functionality from other sites, but the filtering and sorting can keep you from having to eye-ball items when using more specific criteria.

Thanks alot man!

It’s funny how this tool for flipping is actually good enough to render flipping near on impossible/impractical in the future… Which is how you know the tool is good.

Ed Guardian.4825:

It’s funny how this tool for flipping is actually good enough to render flipping near on impossible/impractical in the future… Which is how you know the tool is good.

Thanks for the compliment on the tool . I do have to say, though, that I don’t think any flipping tool will ever make flipping impossible or impractical.

There will always be items that have a >15% differences in price. Some items will become more / less valuable as ANet releases updates for the game, there will be newer trends, and you can always count on people being impatient and using “buy it now” or “sell it now” options (not that there is anything wrong with that).

I’m sure some people speculated that 3rd party TP crawling sites would be the end of flipping