# 💰 \[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:** 16\ **Page:** 4
**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:** [March 11, 2019, 3:52pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/62 "2019-03-11T15:52:18Z")
This is a great starting tool for anyone looking to investigate rough estimate profits on the fly ---
**Author:** ![Jack\_Cassidy](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/jack_cassidy/32/119165_2.png) [@Jack\_Cassidy](https://forums.eveonline.com/u/Jack_Cassidy)\ **Post date:** [March 14, 2019, 9:09am UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/63 "2019-03-14T09:09:45Z")
I seem to be having issues with some Items returning 0 for 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:** [March 14, 2019, 1:29pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/64 "2019-03-14T13:29:20Z")
I do use eve marketer api and I did see last night that it wasn’t returning prices on some items. May just have to wait it out ---
**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:** [March 24, 2019, 5:37am UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/65 "2019-03-24T05:37:37Z")
My taxes calculation was off by a very very small margin, I’ve just updated it and confirms it matches in games to the decimal. For those who dont want to reclone update the following: Update the formula in F2 to be `=((C2 * TotalSellFee) + (D2 * TotalBuyFee))` And then you need to click the little square in the bottom right hand corner of F2 and drag it all the way down to the last row of the F column to apply that forumla to all of F ---
**Author:** ![Nunosh](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/nunosh/32/378366_2.png) [@Nunosh](https://forums.eveonline.com/u/Nunosh)\ **Post date:** [March 26, 2019, 11:19am UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/66 "2019-03-26T11:19:20Z")
Many thanks for this speadsheet. Tonight I’m gonna try to add a second column so I can have 2 vs 2 hubs instead of 1 vs 1, but I guess the drop down menu will be tricky ---
**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:** [March 26, 2019, 4:16pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/67 "2019-03-26T16:16:19Z")
Not hard, but you will want to become very familiar with Named Ranges, as thats where most of the magic resides. ---
**Author:** ![Reileen\_Kawahara](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/reileen_kawahara/32/399303_2.png) [@Reileen\_Kawahara](https://forums.eveonline.com/u/Reileen_Kawahara)\ **Post date:** [April 9, 2019, 6:42pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/68 "2019-04-09T18:42:21Z")
Hi, great sheet but I had an old one with 1000 lines and I copied and pasted the items but although the typeid updates, all the prices do not? I copied and pasted the rows but it wont go past row 153, any idea what I am doing wrong? ---
**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:** [April 9, 2019, 10:37pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/69 "2019-04-09T22:37:26Z")
153 is the happy limit for google sheets, past that it gets grumpy ---
**Author:** ![Reileen\_Kawahara](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/reileen_kawahara/32/399303_2.png) [@Reileen\_Kawahara](https://forums.eveonline.com/u/Reileen_Kawahara)\ **Post date:** [April 10, 2019, 8:50am UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/70 "2019-04-10T08:50:11Z")
Is there another way I could get the prices? My sheet has them and I use vlookups to pull the prices in for numerous items I build as I use a production line to build all components etc. ---
**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:** [April 10, 2019, 2:18pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/71 "2019-04-10T14:18:38Z")
You can try expanding past 153. You just have to apply each columns formula further down ---
**Author:** ![Reileen\_Kawahara](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/reileen_kawahara/32/399303_2.png) [@Reileen\_Kawahara](https://forums.eveonline.com/u/Reileen_Kawahara)\ **Post date:** [April 10, 2019, 3:33pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/72 "2019-04-10T15:33:20Z")
I have already tried that and all I get is N/A. ---
**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:** [June 19, 2019, 11:27am UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/73 "2019-06-19T11:27:42Z")
prioritise your products into relevant tabs. ---
**Author:** ![Phoebe\_Mettalmag](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/phoebe_mettalmag/32/378412_2.png) [@Phoebe\_Mettalmag](https://forums.eveonline.com/u/Phoebe_Mettalmag)\ **Post date:** [July 12, 2019, 6:25pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/74 "2019-07-12T18:25:48Z")
great spreadsheet all what I needed, question about Markup tab, I have no idea what is it, confused. Also is it possible to get the amount of items? I mean to input like 5 Hulks and see the net potential ---
**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:** [July 12, 2019, 6:31pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/75 "2019-07-12T18:31:48Z")
A year ago, someone asked for a markup column and gave me this formula to apply: `nope actually just add a new colum, (profit total/cost)*100` [Link about the difference between markup and margin](https://www.patriotsoftware.com/accounting/training/blog/margin-vs-markup-chart-infographic/) And as far as getting the possible amount of items for your example of 5 hulks, that would easier just to add yourself in a new column and very simple to do. Just do a simple `=sum(Cell1 * Cell2)` where Cell1 is the cell you want to get ( I assume it would be the net profit) and have another cell where you input the count ---
**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:** [July 17, 2019, 1:25am UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/76 "2019-07-17T01:25:15Z")
Added in the Volume returned from the EveMarketer API. Added in a FAQ page with some frequently asked questions Did a bit of color redo to clean things up ---
**Author:** ![system](https://global.discourse-cdn.com/eveonline/original/3X/4/1/41ec4921cbaca7a6f9ea556e7cc20018461eae5e.png) [@system](https://forums.eveonline.com/u/system)\ **Post date:** [October 15, 2019, 1:25am UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/77 "2019-10-15T01:25:15Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed. [Previous page](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376.md?page=3)