can spreadsheet be used by corp or only indivisual pilots. I have market corp I run and all my toons, but also in a corp with 5+ market traders how can I combine it all?
I seem to have some issues with the sheet. I bought and sold some stuff, and the transactions tab does contain that info, but within the master tab, the sum of purchases, sales, quantity, and avg purchase/sale stay 0, # DIV/0, or N/A. Same with Taxes&Fees. Everything else looks correct. EDIT: This appears to happen due to the newly added "Margin" tab in jeveassets. The hotfix is to either delete, or simply move that tab all the way to the right, then copy into the sheet. I found this info on your discord, so you may want to link it in your description. I only found it randomly in one of your past streams in the chat. :)
Hey OZ, I'm unsure now if I'm mega stupid, or if something changed since making this video. Is the spreadsheet still available for download? Because when I go to try, it says pretty much that users without write-permission aren't allowed to download, so I can only look at it.
So if I understand this correctly, I basically copy-paste the transactions OVER THE OLD ONES, then copy-paste these new item names to the master sheet, EACH TIME OVERWRITING THE OLD DATA, correct?
@@OZeve Thank you. Looking forward to it. As I have started trading only today, I have essentially 0 trade history literally and figurately (no experience with trading in other games either). I had a starting capital of 2 billion from my combat pilot doing missions. Let's see where it takes me... Does jeveassets hold my entire transaction history? If I copy over the transactions tomorrow, will those of today be included too, thereby keeping my history on the sheets intact? Or does this history actually not matter, and if so, why? Thanks for your help.
@@OZeve Hello :) First of all, huge thanks for this! I really appreciate you sharing this :) Is there already a update for the new way of doing it? :) Thank you!
@@satnoanix9283 I have not implemented it into the public sheet yet. It is only a small change since I do a check against existing items on the transaction sheet so you don't need to copy all of them over. But I actually don't think it saves much time. With Google Sheets copy all and remove duplicates it's quite quick and easy.
You can‘t. It‘s a google sheet. I chose that format to allow everyone to use it, not just the ones who can afford MS Excel. You just make a local copy for yourself.
Hmmm I paste transactions and master tabs , removed duplicats but now everywhere I look I have errors div/0 , n/a, n/d. Looks like its caused by Load Jita,Dodi,Amarr tabs formula in A1 gets #NAME? error. Do I have to fill those tabs myself? Using excell , and downloaded spreadsheet from your link (in excell format).
Hi Oz I hope you have a great holiday. When you get back can you tell me where to find the Spreadsheet download please. I have watched you video a few times over the months but just not find the spreadsheet download on the home page below the video box?
Follow the link below and go to File > Make a copy. After naming the sheet you will have a copy in your own Google Sheets filesystem and can edit and use it. docs.google.com/spreadsheets/d/1NV1jRo9glgkI6FawJA1WvzJOwizxjIskfMgAhRdN5YM/edit?usp=sharing
Unfortunately, i have a tons of bugs everytime I use a google templated excel. In this case, it's not updating "sum of purchases" column besides the fact, that the same formular is working on purchase qty. So frustrating but not your fault obviously
@@ulyantonov4693 it's only needed if your transaction export is not using US number annotation. Switch the comma and the point in all numbers (search and replace). It will work afterwards
I can't download the spreadsheet. I open it on google docs, everything looks fine. Then I download it but I end up with the other sheet for the fund or something instead of the sheet you talk about in your videos. Or am I just confused? lol
@@OZeve thanks man loving the content, im jokervxxv from the stream, made 20mill prof on my first day trading in jita alone setting up amarr an dixie tomorrow, how more people dont know about you is beyond me, this advice is golden!!! Will be in touch tomorrow about investment with my omega toon
Love your videos. Is there any possibility that you could to a quick guide on how to change the Forge Buy column to a different station. And a simple guide on how to make a simple sell to sell orders sheet? With basic stuff like sorting colums and fastest way to add items that is not in assest list.
