# Trading spreadsheets guide/help

**URL:** <https://forums.eveonline.com/t/trading-spreadsheets-guide-help/292488>\
**Category:** Science & Industry\
**Created:** [January 28, 2021, 9:38pm UTC](https://forums.eveonline.com/t/trading-spreadsheets-guide-help/292488 "2021-01-28T21:38:41Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Doktoras\_Dumas\_Codie](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/doktoras_dumas_codie/32/252961_2.png) [@Doktoras\_Dumas\_Codie](https://forums.eveonline.com/u/Doktoras_Dumas_Codie)\
**Post date:** [January 28, 2021, 9:38pm UTC](https://forums.eveonline.com/t/trading-spreadsheets-guide-help/292488/1 "2021-01-28T21:38:41Z")

</div>

I about 15 days into station trading and station \<–\> station trading. I was wondering if anyone could help me modify this [free market spreadsheet](https://docs.google.com/spreadsheets/d/1Cxon0qxkeBm-DcRkNQjxUS_RCRDKNkteGpRpodVwKOk/copy). I would like to know how to add Hek (or any station) to the drop-down menu of the buy column. And how do I copy the sell column and it’s formula so that I have two of them next to each other. This is what I had in mind → [https://i.imgur.com/XACPLpw.jpg](https://i.imgur.com/XACPLpw.jpg)

And I know that google spreadsheets seem to have a200 item limitation so I assume I just have to make a few copies.

---

<div class="post-metadata">

**Author:** ![Lis\_Torin](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/lis_torin/32/204820_2.png) [@Lis\_Torin](https://forums.eveonline.com/u/Lis_Torin)\
**Post date:** [January 29, 2021, 7:34am UTC](https://forums.eveonline.com/t/trading-spreadsheets-guide-help/292488/2 "2021-01-29T07:34:45Z")

</div>

In the tab “math”. you need to add Hek and edit formula in buy/sell swap so it will be in drop down menu. You can pull data for whole region instead system. That way, for example it will also pull perimeter prices not only from Jita. Just double check prices in game since it will show best prices for **whole region**

You can also transform sheet to single station price check for station trading. Just need to change ending of formula in tab “trading” C2 and E2. “//sell/min” “//buy/max” etc. Use google to find other options.

Sheet has limit of 152 items. After that google sheets likes to bug out. You need to make copies of sheet to have more items

---

<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 29, 2021, 7:35am UTC](https://forums.eveonline.com/t/trading-spreadsheets-guide-help/292488/3 "2021-04-29T07:35:45Z")

</div>

Closed on April 29, 2021, 7:35am UTC

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