These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

Market Discussions

 
  • Topic is locked indefinitely.
 

Average price of bought items (station trading)

First post
Author
Previous Topic Next Topic
Krel Aifolin
Russian Crime Syndicate
#1 - 2017-01-08 09:18:07 UTC
Hi there! Hi station traders. How you calculate average price of bought items? Now I open wallet transaction log and then transfer all deals to excel. Then I calculate average price for each position. It's so hard. I can't imagine what will happen when I will use more orders. I think my system breaks down :)
Is there any soft, programs or scripts where I can automatically calculate average price?

Thanks a lot, sorry for my English.

Russian Crime Syndicate - Corporation of bribetakers, killers, scums, liars. thieves. We trade weapons and drugs. Human trafficking is our main business. Good business for bad people. Still wanna be one of us?
Otago Dogwalker
Brave Newbies Inc.
Brave Collective
#2 - 2017-01-08 09:34:18 UTC
Hi Krel.

Your english is good, better than my Russian anyway.

Have you seen https://eve-central.com/

This gives prices for all systems rather than regional prices so you can see what your stuff will sell for (if you are prepared to haul it...

Otago
Krel Aifolin
Russian Crime Syndicate
#3 - 2017-01-08 09:42:51 UTC  |  Edited by: Krel Aifolin
Otago Dogwalker wrote:
Hi Krel.

Your english is good, better than my Russian anyway.

Have you seen https://eve-central.com/

This gives prices for all systems rather than regional prices so you can see what your stuff will sell for (if you are prepared to haul it...

Otago


ty for you answer. Yep, I know about eve-central. But I have another problem.

example.

I bought one item. It may be 1 x Inetrial stabilizer. Price 1000 Isk. Then I bought another one. Price 500 ISK. Now I have 2 stabilizers and their average price = (1000+500)/2=750 ISk for 1 stabilizer. Right?

I want buy more than 5 positions. And for all positions I need average price of bought items

Russian Crime Syndicate - Corporation of bribetakers, killers, scums, liars. thieves. We trade weapons and drugs. Human trafficking is our main business. Good business for bad people. Still wanna be one of us?
Krel Aifolin
Russian Crime Syndicate
#4 - 2017-01-08 12:44:07 UTC
I googled all possible sites for 4 days in english and russian web. I watched all videos on youtube in two languages. But no one discuss about average price. How could this happen? I think it's really important topic if you want trade at market. If you buy goods for sale you must know average price for all your positions, I think. Am I wrong? It helps you know your lowest price.

Really nobody calculate this data? Shocked I'm confused. Traders, how you trade if you don't know this data? Or maybe it secret? Or maybe I want much? Or nobody understand me? Ugh

If someone also wants to resolve this issue, let me know here. Let's discuss together how to solve this problem.

Russian Crime Syndicate - Corporation of bribetakers, killers, scums, liars. thieves. We trade weapons and drugs. Human trafficking is our main business. Good business for bad people. Still wanna be one of us?
Eternus8lux8lucis
Guardians of the Gate
RAZOR Alliance
#5 - 2017-01-08 13:41:11 UTC
Only program I know of that Ive seen so far was "eve mentat" but google search says it might not have been updated since 2015 sometime. So not sure whats out there available atm.

Have you heard anything I've said?

You said it's all circling the drain, the whole universe. Right?

That's right.

Had to end sometime.
Salvos Rhoska
#6 - 2017-01-08 15:34:33 UTC
If you mean tracking how much you have invested per unit in your stock of an item, perhaps there are some premade spreadsheets you can use, or 3rd party inventory tracking programs used by IRL retailers.

PvE v PvP <> Old School Exploration <> CODE Licenses <> CODE Special Agent
Krel Aifolin
Russian Crime Syndicate
#7 - 2017-01-08 16:48:19 UTC
Salvos Rhoska wrote:
If you mean tracking how much you have invested per unit in your stock of an item, perhaps there are some premade spreadsheets you can use, or 3rd party inventory tracking programs used by IRL retailers.


Yes! Exactly!

Now I use spreadsheets. And it is very hard work without automation. IRL retailers - in real life retailers? I thought about it. I want know what programs use eve-traiders.


If you use spreadsheets - great. If you use IRL retailer's programs - good. Tell us about this programs. Maybe you use API->spreadsheet. Maybe api->IRL retailer's programs or any other method. Tell us. It will really helpful for newbie eve-traiders.

Russian Crime Syndicate - Corporation of bribetakers, killers, scums, liars. thieves. We trade weapons and drugs. Human trafficking is our main business. Good business for bad people. Still wanna be one of us?
Salvos Rhoska
#8 - 2017-01-08 17:36:23 UTC  |  Edited by: Salvos Rhoska
I think in both cases of a dedicated spreadsheet, or a 3rd party retailer inventory program, you would still have to enter the values manually.

If there is some program that allows a simpler form of copypaste, I dont know of it, much less if there is a program that can draw it from your API.

Sorry, this is the most I can do.

Perhaps try asking in the Market Discussion forum.

PvE v PvP <> Old School Exploration <> CODE Licenses <> CODE Special Agent
Scipio Artelius
Weaponised Vegemite
Flying Dangerous
#9 - 2017-01-08 17:41:48 UTC
https://www.eve-mogul.com/

That is what I use for my industry/trading alt.

Here is an actively maintained list of third party tools for the game, including market tools:

https://github.com/devfleet/awesome-eve
ISD Decoy
ISD Community Communications Liaisons
ISD Alliance
#10 - 2017-01-08 18:27:05 UTC
Moved to Market Discussions.

ISD Decoy

Captain

Community Communication Liaisons (CCLs)

Interstellar Services Department
Krel Aifolin
Russian Crime Syndicate
#11 - 2017-01-08 19:07:15 UTC
Thank you all. I think I need my own script for my needs. :) I see my request very specific. I have started write python script in which I will realize my ideas. I see EVE API provides sufficient functionality for any crazy ideas.

Scipio Artelius, thank you. Service does not provide the necessary functionality for me.

ISD Decoy, you right. This topic about market, trading, soft for trading. ty too.

Russian Crime Syndicate - Corporation of bribetakers, killers, scums, liars. thieves. We trade weapons and drugs. Human trafficking is our main business. Good business for bad people. Still wanna be one of us?
Teckos Pech
Hogyoku
Goonswarm Federation
#12 - 2017-01-08 21:41:24 UTC  |  Edited by: Teckos Pech
Krel Aifolin wrote:
Hi there! Hi station traders. How you calculate average price of bought items? Now I open wallet transaction log and then transfer all deals to excel. Then I calculate average price for each position. It's so hard. I can't imagine what will happen when I will use more orders. I think my system breaks down :)
Is there any soft, programs or scripts where I can automatically calculate average price?

Thanks a lot, sorry for my English.


There are lots of software packages that can read in things like a CSV file and from there you can do all sorts of things. I'm sure some are even free to download. For example R is available under the GNU license and is free. Not sure if it can read in the files you download.

And if it can, what works in CSV or Excel may not work in R, especially the variable names. That is one problem I run into with SAS all the time. Somebody will send me an Excel file and it is in a terrible format for statistical analysis and the Variable names stink (e.g. they'll use variable names like "Trans Revenue 2016" where SAS will often barf, so I have to go in and change it to something like Trans_Rev_2016). And often times it the data is arranged badly for use in statistical anlysis...thank whomever came up with Proc Transpose.

"The curious task of economics is to demonstrate to men how little they really know about what they imagine they can design."--Friedrich August von Hayek

8 Golden Rules for EVE Online
Black Locust
Imperial Shipment
Amarr Empire
#13 - 2017-01-09 13:20:15 UTC
If you have excel, you could use a pivot table. Or failing that, install LAMP / WAMP on your computer and load your transactions into MySQL, it would be a fairly simple calculation for either a pivot table or SQL query.
Krel Aifolin
Russian Crime Syndicate
#14 - 2017-01-10 13:39:12 UTC
Yep, SQL queries is good idea too. If needed, I will use SQL queries in the future. However, I think that best solution is a simple python script.

Russian Crime Syndicate - Corporation of bribetakers, killers, scums, liars. thieves. We trade weapons and drugs. Human trafficking is our main business. Good business for bad people. Still wanna be one of us?
James Zealot
Science and Trade Institute
Caldari State
#15 - 2017-01-11 20:38:43 UTC
I think evetrademaster might help as well.