# đź’° \[FREE SERVICE\] Free Trade Spreadsheet đź’° **URL:** \ **Category:** Services\ **Created:** [December 19, 2017, 8:24pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376 "2017-12-19T20:24:06Z")\ **Posts on this page:** 20\ **Page:** 3
**Author:** ![Brock\_Khans](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/brock_khans/32/409174_2.png) [@Brock\_Khans](https://forums.eveonline.com/u/Brock_Khans)\ **Post date:** [August 13, 2018, 10:52pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/42 "2018-08-13T22:52:58Z")
Try ctrl shift v instead of normal ctrl v ---
**Author:** ![Liute](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/liute/32/257518_2.png) [@Liute](https://forums.eveonline.com/u/Liute)\ **Post date:** [August 14, 2018, 1:54pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/43 "2018-08-14T13:54:03Z")
nvm found solution its some other kind of " " space so i just did copy that space and paste in substitude inside “” and it worked lol. ---
**Author:** ![Brock\_Khans](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/brock_khans/32/409174_2.png) [@Brock\_Khans](https://forums.eveonline.com/u/Brock_Khans)\ **Post date:** [August 28, 2018, 7:30pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/44 "2018-08-28T19:30:19Z")
Getting quite a few people requesting access to my trade sheet. You need to be going to File -\> Make Copy instead, so you now have your own private copy ---
**Author:** ![Lee\_Spicer](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/lee_spicer/32/266320_2.png) [@Lee\_Spicer](https://forums.eveonline.com/u/Lee_Spicer)\ **Post date:** [September 6, 2018, 12:54pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/45 "2018-09-06T12:54:43Z")
How would I add a refresh button or what would be a easy way to trigger a refresh of the prices? ---
**Author:** ![Brock\_Khans](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/brock_khans/32/409174_2.png) [@Brock\_Khans](https://forums.eveonline.com/u/Brock_Khans)\ **Post date:** [September 6, 2018, 1:08pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/46 "2018-09-06T13:08:01Z")
Just google : auto refresh google sheet ---
**Author:** ![Ryan\_B\_Thiesant](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/ryan_b_thiesant/32/293156_2.png) [@Ryan\_B\_Thiesant](https://forums.eveonline.com/u/Ryan_B_Thiesant)\ **Post date:** [September 11, 2018, 1:02pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/47 "2018-09-11T13:02:07Z")
> [@Lee\_Spicer](#): > > How would I add a refresh button or what would be a easy way to trigger a refresh of the prices? Kinda thinking spamming that will get the feed x’d for good. ---
**Author:** ![Bubbarabb\_Stjames](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/bubbarabb_stjames/32/120707_2.png) [@Bubbarabb\_Stjames](https://forums.eveonline.com/u/Bubbarabb_Stjames)\ **Post date:** [September 23, 2018, 1:47pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/48 "2018-09-23T13:47:48Z")
70 @Brock_Khans, how would I go about, or how much would it cost to get this setup for like a region trading setup? including volumes of orders bought and sold the day of the refresh? you can evemail me in game if that makes it easier to respond. Thanks for the awesome spreadsheet! ---
**Author:** ![Brock\_Khans](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/brock_khans/32/409174_2.png) [@Brock\_Khans](https://forums.eveonline.com/u/Brock_Khans)\ **Post date:** [September 23, 2018, 2:31pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/49 "2018-09-23T14:31:21Z")
I use evemarketer api. They have the region data , you would just need to add a new call. Right now I only do solar system calls [https://api.evemarketer.com/ec/](https://api.evemarketer.com/ec/) Not in a position to help beyond that ---
**Author:** ![Bubbarabb\_Stjames](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/bubbarabb_stjames/32/120707_2.png) [@Bubbarabb\_Stjames](https://forums.eveonline.com/u/Bubbarabb_Stjames)\ **Post date:** [September 23, 2018, 2:43pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/50 "2018-09-23T14:43:24Z")
cool. thats fine. i aint technically savvy like that so hope you can get to that eventually. thanks anyway man. ---
**Author:** ![Brock\_Khans](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/brock_khans/32/409174_2.png) [@Brock\_Khans](https://forums.eveonline.com/u/Brock_Khans)\ **Post date:** [December 6, 2018, 4:29am UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/51 "2018-12-06T04:29:20Z")
Still a great sheet to try out for beginners! ---
**Author:** ![Tzn-Su\_Tsutola](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/tzn-su_tsutola/32/110195_2.png) [@Tzn-Su\_Tsutola](https://forums.eveonline.com/u/Tzn-Su_Tsutola)\ **Post date:** [December 10, 2018, 5:34am UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/52 "2018-12-10T05:34:00Z")
If I delete a row, how can I add it back later on? I tried just typing an item name there but it doesn’t work. ---
**Author:** ![Brock\_Khans](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/brock_khans/32/409174_2.png) [@Brock\_Khans](https://forums.eveonline.com/u/Brock_Khans)\ **Post date:** [December 10, 2018, 6:21am UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/53 "2018-12-10T06:21:23Z")
I generally wouldn’t ever delete rows. You may need to add it back into the ranges in some of the formulas > **[Screenshot](https://prnt.sc/lsx5yr)** > > Captured with Lightshot and dragging down the blue square on some of the others. > **[Screenshot](https://prnt.sc/lsx5q4)** > > Captured with Lightshot ---
**Author:** ![Tzn-Su\_Tsutola](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/tzn-su_tsutola/32/110195_2.png) [@Tzn-Su\_Tsutola](https://forums.eveonline.com/u/Tzn-Su_Tsutola)\ **Post date:** [December 10, 2018, 6:37am UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/54 "2018-12-10T06:37:46Z")
I’ll leave them alone.lol can I leave the row blank? if I currently try it makes all rows stop working. ---
**Author:** ![Brock\_Khans](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/brock_khans/32/409174_2.png) [@Brock\_Khans](https://forums.eveonline.com/u/Brock_Khans)\ **Post date:** [December 10, 2018, 4:28pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/55 "2018-12-10T16:28:21Z")
I don’t believe so, if anything just put tritanium in all the ones you don’t care about ---
**Author:** ![Tzn-Su\_Tsutola](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/tzn-su_tsutola/32/110195_2.png) [@Tzn-Su\_Tsutola](https://forums.eveonline.com/u/Tzn-Su_Tsutola)\ **Post date:** [December 11, 2018, 5:47am UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/56 "2018-12-11T05:47:10Z")
I did just that, thanks for the tip, with such a small price number it makes it easy to differentiate between my orders and whats “blank” lol ---
**Author:** ![Tzn-Su\_Tsutola](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/tzn-su_tsutola/32/110195_2.png) [@Tzn-Su\_Tsutola](https://forums.eveonline.com/u/Tzn-Su_Tsutola)\ **Post date:** [December 13, 2018, 6:19am UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/57 "2018-12-13T06:19:09Z")
On another note how hard would it be for me to add a volume column and figure out how many buy orders are being made vs sell orders, would that be possible or is it wishful thinking. ---
**Author:** ![CaptainCool](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/captaincool/32/180294_2.png) [@CaptainCool](https://forums.eveonline.com/u/CaptainCool)\ **Post date:** [December 13, 2018, 10:28am UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/58 "2018-12-13T10:28:28Z")
Hero! I really needed this! But I can seem to add new items to work… I’ve tried just typing the item name in the far left column below the last item(Breacher) but the prices don’t show up. Have also tried manually putting in the typeID using =vlookup(…), still, don’t work. Am I doing anything wrong? ![22742e416613ccdeb63f8972bbf51618](https://global.discourse-cdn.com/eveonline/original/3X/7/3/7307617f9ffabc54b4f77415901ef6a0d1f34312.png) ---
**Author:** ![Brock\_Khans](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/brock_khans/32/409174_2.png) [@Brock\_Khans](https://forums.eveonline.com/u/Brock_Khans)\ **Post date:** [December 13, 2018, 5:12pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/59 "2018-12-13T17:12:13Z")
> [@Tzn-Su\_Tsutola](#): > > On another note how hard would it be for me to add a volume column and figure out how many buy orders are being made vs sell orders, would that be possible or is it wishful thinking. I use the evemarkerter API to supply prices, and currently only get the sell/buy data, however you can look over what is returned in the GET request here [https://api.evemarketer.com/ec/](https://api.evemarketer.com/ec/) to what information is also available for you to pull down ---
**Author:** ![Brock\_Khans](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/brock_khans/32/409174_2.png) [@Brock\_Khans](https://forums.eveonline.com/u/Brock_Khans)\ **Post date:** [December 13, 2018, 5:13pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/60 "2018-12-13T17:13:03Z")
> [@CaptainCool](#): > > But I can seem to add new items to work… I’ve tried just typing the item name in the far left column below the last item(Breacher) but the prices don’t show up. 155 rows seems to be the soft/hard limit before googlsheets starts to complain at you for excessive calls in/out of your google sheet. Which is why I stopped there ---
**Author:** ![Tzn-Su\_Tsutola](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/tzn-su_tsutola/32/110195_2.png) [@Tzn-Su\_Tsutola](https://forums.eveonline.com/u/Tzn-Su_Tsutola)\ **Post date:** [December 13, 2018, 9:47pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/61 "2018-12-13T21:47:50Z")
Thanks, now I just need to figure out what it is I’m looking at.lol your sheet has been awesome so far. [Previous page](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376.md?page=2) [Next page](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376.md?page=4)