Does anyone have any suggestions for obtaining trade data in CSV form? My goal is downloading for use in Excel.
For the past few years, I've used GW2TP.com for all my trading data. I stopped using GW2Spidy.com because it wasn't keeping up with API changes, while 'TP' was, notably it was slow to add new items or new item types. 'TP' hasn't added new items since Halloween (and it was slow to get those, too), so I've switched back to Spidy.
I'd like to be less dependent on those sites, since it seems the developers haven't had as much time/interest in keeping them up-to-date. Unfortunately, I'm old school: Excel is my tool of choice and I prefer to be able to work offline, rather than have to sign in to Google apps etc.
The API is in JSON form and, as a spreadsheet program, Excel doesn't come with any tools for importing it. The main data I want is highest-buy|lowest-sell offers. Supply & demand is nice, but not essential. Item names & other details are much easier to find through other sources, so I can live without them, although I do like that Spidy's API has it all.
I probably update prices a few times a day; I want current data, but I don't need frequent updates.
Any suggestions for sites that already offer a CSV via their own API?
If there aren't, any recommendations for how to bootstrap my own tool to convert JSON to something Excel can read? Does anyone have something they already use?
Thanks in advance.
"Face the facts. Then act on them. It's ...the only doctrine I have to offer you, & it's harder than you'd think, because I swear humans seem hardwired to do anything but. Face the facts. Don't pray, don't wish, ...FACE THE FACTS. THEN act." — Quellcrist Falconer