# Spreadsheet Updates

**URL:** <https://forums.eveonline.com/t/spreadsheet-updates/102987>\
**Category:** Science & Industry\
**Created:** [September 2, 2018, 7:29pm UTC](https://forums.eveonline.com/t/spreadsheet-updates/102987 "2018-09-02T19:29:54Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Guiliano\_Thellere](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/guiliano_thellere/32/327551_2.png) [@Guiliano\_Thellere](https://forums.eveonline.com/u/Guiliano_Thellere)\
**Post date:** [September 2, 2018, 7:29pm UTC](https://forums.eveonline.com/t/spreadsheet-updates/102987/1 "2018-09-02T19:29:54Z")

</div>

Does anyone know if the following spreadsheet has been updated to pull market data since changes to API with a current version available? If not, can anyone explain how I can update this myself please?

Thanks all!

> **[\[Make a Copy\]PI Production Cost Projection by Wyke Mossari edited by Paramys & Murloc Bait](https://docs.google.com/spreadsheets/d/1RgW6FaNBH2R13bu9VtdpaF0gMfNESOgVGnkfiJ3VRSY/edit#gid=27)**
>
> P1-&gt; P4
> 
> v. 20, Enter Your Region( Must Be Spelled Exactly;" Global" accepted):, the forge, Eve-Metrics: 0 Eve-Central: 1, 1, C1, C2, C3
> Type ID, Target Type, Regional Sell Min, Regional Buy Max, Enter Your Own Buy Price, Effective Tax Rate of...

---

<div class="post-metadata">

**Author:** ![Whitehound](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/whitehound/32/59604_2.png) [@Whitehound](https://forums.eveonline.com/u/Whitehound)\
**Post date:** [September 2, 2018, 7:34pm UTC](https://forums.eveonline.com/t/spreadsheet-updates/102987/2 "2018-09-02T19:34:37Z")

</div>

You better ask in the [3rd Party Developers](https://forums.eveonline.com/c/technology-research/third-party-developers) forum. There you’ll find other apps that make use of Google spreadsheets.

For the spreadsheet you have, it looks pretty much broken. The few prices that are in there look way off and EVE Central has gone out of service a while ago.

---

<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:** [September 2, 2018, 11:31pm UTC](https://forums.eveonline.com/t/spreadsheet-updates/102987/3 "2018-09-02T23:31:31Z")

</div>

> [@Guiliano\_Thellere](#):
>
> Does anyone know if the following spreadsheet has been updated to pull market data since changes to API with a current version available?

Answer to this is, No. It still set to use [eve-central.com](http://eve-central.com) which as you know is dead, however it’s fairly easy to make it work, if you do the following:

On the “eve-metrics prices” sheet

- in cell B1, C1, D1 and E1 replace /evec\_api/marketstat/type/ in the formulas so that it just reads: //sell/min , //buy/avg , //buy/max , //buy/max
- In the formula in cell G1 it should be “[http://api.evemarketer.com/ec/marketstat?](http://api.evemarketer.com/ec/marketstat?)” instead of the eve-central one.

this could possibly fix most of it, if not all?

---

<div class="post-metadata">

**Author:** ![Guiliano\_Thellere](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/guiliano_thellere/32/327551_2.png) [@Guiliano\_Thellere](https://forums.eveonline.com/u/Guiliano_Thellere)\
**Post date:** [September 3, 2018, 7:42am UTC](https://forums.eveonline.com/t/spreadsheet-updates/102987/4 "2018-09-03T07:42:07Z")

</div>

Thanks @ISD_Sakimura, this fix has solved the entire spreadsheet! 👍

---

<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:** [September 3, 2018, 8:39am UTC](https://forums.eveonline.com/t/spreadsheet-updates/102987/5 "2018-09-03T08:39:56Z")

</div>

> [@Guiliano\_Thellere](#):
>
> this fix has solved the entire spreadsheet!

just noticed a slight error in the change you should make

> [@ISD\_Sakimura](#):
>
> - in cell B1, C1, D1 and E1 replace /evec\_api/marketstat/type/ in the formulas so that it just reads: //sell/min , //buy/avg , //buy/max , //buy/max

Should be //sell/min , //buy/avg , //buy/max , //buy/avg

---

<div class="post-metadata">

**Author:** ![Guiliano\_Thellere](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/guiliano_thellere/32/327551_2.png) [@Guiliano\_Thellere](https://forums.eveonline.com/u/Guiliano_Thellere)\
**Post date:** [September 3, 2018, 12:13pm UTC](https://forums.eveonline.com/t/spreadsheet-updates/102987/6 "2018-09-03T12:13:56Z")

</div>

No worries, I picked up on that whilst editing the sheet and changed accordingly

---

<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:** [December 2, 2018, 12:14pm UTC](https://forums.eveonline.com/t/spreadsheet-updates/102987/7 "2018-12-02T12:14:00Z")

</div>

Closed on December 2, 2018, 12:14pm UTC

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