# Spreadsheets

**URL:** <https://forums.eveonline.com/t/spreadsheets/44424>\
**Category:** Science & Industry\
**Created:** [December 9, 2017, 8:08pm UTC](https://forums.eveonline.com/t/spreadsheets/44424 "2017-12-09T20:08:11Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![Leesal\_Delsa](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/leesal_delsa/32/381339_2.png) [@Leesal\_Delsa](https://forums.eveonline.com/u/Leesal_Delsa)\
**Post date:** [December 9, 2017, 8:08pm UTC](https://forums.eveonline.com/t/spreadsheets/44424/1 "2017-12-09T20:08:11Z")

</div>

hey anyone have any updated spreedsheets working with jita pricing since eve central went down?

i’m not sure if this is the right place to post this but anything helps!!

---

<div class="post-metadata">

**Author:** ![ISD\_Sakimura](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/isd_sakimura/32/382213_2.png) [@ISD\_Sakimura](https://forums.eveonline.com/u/ISD_Sakimura)\
**Post date:** [December 10, 2017, 12:33pm UTC](https://forums.eveonline.com/t/spreadsheets/44424/2 "2017-12-10T12:33:06Z")

</div>

You can use the [https://evemarketer.com/](https://evemarketer.com/) (3rd party site) instead of EVE-central, they use very similar API’s and as such it’s very easy to adjust your spreadsheets.

---

<div class="post-metadata">

**Author:** ![Oriella\_Trikassi](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/oriella_trikassi/32/376749_2.png) [@Oriella\_Trikassi](https://forums.eveonline.com/u/Oriella_Trikassi)\
**Post date:** [December 10, 2017, 2:29pm UTC](https://forums.eveonline.com/t/spreadsheets/44424/3 "2017-12-10T14:29:35Z")

</div>

I use a price dump from Eve market data, the whole lot in a mere 10,000 rows!

[http://api.eve-marketdata.com/api/item\_prices2.xml?char\_name=Oriella](http://api.eve-marketdata.com/api/item_prices2.xml?char_name=Oriella) Trikassi&solarsystem\_ids=30000142&buysell=b

---

<div class="post-metadata">

**Author:** ![Evenmoar\_McSalts](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/evenmoar_mcsalts/32/47505_2.png) [@Evenmoar\_McSalts](https://forums.eveonline.com/u/Evenmoar_McSalts)\
**Post date:** [January 5, 2018, 2:44am UTC](https://forums.eveonline.com/t/spreadsheets/44424/4 "2018-01-05T02:44:44Z")

</div>

So I feel like I’m about to lose my mind. I’ve been researching this topic for 3 days now and have gotten nowhere ☹ I don’t have any current spreadsheets, was looking to make my own from scratch. If I can just figure out how to pull current pricing by location to a google doc I’ll be happy. I’ve gone through the fuzzworks guide, that hasn’t worked. I don’t think I have the knowledge base to understand what he’s saying when he refers to the eve-marketdata site, and eve central is down. I’ve tried the eve university, it refers to eve central, which is down. I’ve tried the swagger page, but I can’t seem to get an actual url to plug into my spreadsheet, their stuff seems a lot more complicated. I’ve tried EVEMarketer, but it doesn’t seem to let me search by region and price and use it’s url. I’m really, really stuck and getting a little frustrated at this point.

If there’s anyone that could either give me an example of a working url, like eve-uni has, I know how to find type ids and station ids, that would be amazing. Barring that, if someone would be kind enough to just point me to a website or guide that actually works that I could actually use for this it would be amazingly appreciated. And if someone would be so amazing as to actually maybe like get in comms or something and help me get started, I’d happily give you 5% of the first 100 runs of whatever I make. I just want these stupid things to work, goshdarnit! lol.

---

<div class="post-metadata">

**Author:** ![KenFlorian](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/kenflorian/32/449998_2.png) [@KenFlorian](https://forums.eveonline.com/u/KenFlorian)\
**Post date:** [January 5, 2018, 3:02am UTC](https://forums.eveonline.com/t/spreadsheets/44424/5 "2018-01-05T03:02:07Z")

</div>

Everything you need can probably be done with these two sets of google sheets/ESI code sets.

> [@\[9.2.1 - version 50\] GESI - Google Sheets ESI Add-On - Now an EVE Online Partner!](https://forums.eveonline.com/t/3-3-0-gesi-google-sheets-esi-library/13406):
>
> New post for the new forums. For all the spreadsheets in space people out there: Details are in the readme Enjoy. Discord Server: [GESI](https://discord.gg/eEAH2et) Link to old post:

> **[GitHub - nuadi/googlecrestscript: A Google Sheets script designed to contact...](https://github.com/nuadi/googlecrestscript)**
>
> A Google Sheets script designed to contact the EVE Online CREST/ESI endpoints - GitHub - nuadi/googlecrestscript: A Google Sheets script designed to contact the EVE Online CREST/ESI endpoints

---

<div class="post-metadata">

**Author:** ![Evenmoar\_McSalts](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/evenmoar_mcsalts/32/47505_2.png) [@Evenmoar\_McSalts](https://forums.eveonline.com/u/Evenmoar_McSalts)\
**Post date:** [January 5, 2018, 5:53am UTC](https://forums.eveonline.com/t/spreadsheets/44424/6 "2018-01-05T05:53:25Z")

</div>

Alright I appreciate it! I’ll look at that, started reading the readme and it’s nothing I’ve ever done before, but I’ll give it my best go. Thank you very much!

---

<div class="post-metadata">

**Author:** ![KenFlorian](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/kenflorian/32/449998_2.png) [@KenFlorian](https://forums.eveonline.com/u/KenFlorian)\
**Post date:** [January 5, 2018, 7:48pm UTC](https://forums.eveonline.com/t/spreadsheets/44424/7 "2018-01-05T19:48:17Z")

</div>

You’ll need to build from these but the combination of the two code sets provide everything you need to build your own buy/build/sell tool. Because both use ESI, you are future-proofed…at least for the next many years.

Maybe start with nuadi set which includes a sample for each of the functions he provides.

You’ll probably want to get the static data of all “items” in Eve from here:

[https://developers.eveonline.com/resource/resources](https://developers.eveonline.com/resource/resources)

and get “invTypes” into a Sheet tab.

Learn the function “vlookup()” in Sheets and you’re well on your way.

---

<div class="post-metadata">

**Author:** ![Deriger](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/deriger/32/452991_2.png) [@Deriger](https://forums.eveonline.com/u/Deriger)\
**Post date:** [January 6, 2018, 4:29pm UTC](https://forums.eveonline.com/t/spreadsheets/44424/8 "2018-01-06T16:29:25Z")

</div>

This is where I learned how to do it. [https://www.youtube.com/watch?v=6DuavODssDE](https://www.youtube.com/watch?v=6DuavODssDE)

You just have to update it for the EVEMarketer API.

This will pull Jita prices. [http://api.evemarketer.com/ec/marketstat?usesystem=30000142](http://api.evemarketer.com/ec/marketstat?usesystem=30000142)

---

<div class="post-metadata">

**Author:** ![Evenmoar\_McSalts](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/evenmoar_mcsalts/32/47505_2.png) [@Evenmoar\_McSalts](https://forums.eveonline.com/u/Evenmoar_McSalts)\
**Post date:** [January 14, 2018, 11:57pm UTC](https://forums.eveonline.com/t/spreadsheets/44424/9 "2018-01-14T23:57:53Z")

</div>

Just gotta say, you guys are amazing. I finally got it all figured out, got my spreadsheet working, now have profit calculations for a ton of stuff. THANK YOU!!!

---

<div class="post-metadata">

**Author:** ![KenFlorian](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/kenflorian/32/449998_2.png) [@KenFlorian](https://forums.eveonline.com/u/KenFlorian)\
**Post date:** [January 15, 2018, 6:01pm UTC](https://forums.eveonline.com/t/spreadsheets/44424/10 "2018-01-15T18:01:07Z")

</div>

Another competitor successfully launched.

Bring on the PvP! 😃

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/eveonline/original/3X/4/1/41ec4921cbaca7a6f9ea556e7cc20018461eae5e.png) [@system](https://forums.eveonline.com/u/system)\
**Post date:** [April 15, 2018, 6:01pm UTC](https://forums.eveonline.com/t/spreadsheets/44424/11 "2018-04-15T18:01:32Z")

</div>

Closed on April 15, 2018, 6:01pm UTC

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
