Got it to load successfully (on Vista had to Run As Administrator) and it imported some market reports. Great! But I see here that there is a Windows app for it where various things can be done. Er… how? The IGB part works great but how do I access the rest of it?
Hi.
I don’t undertand how the “market” tab works.
I got the transactions, orders… by the API, but there’s still nothing in this “market” tab.
What did I do wrong?
@Jimky
Unfortunately, there are no ways to import market via API.
Use file or cache import to fill up EVE Mentat’s market browser with data: view market data in game, than click “Cache import” button in market.
Hey, thnx for this lovely app Still figuring it out
I see you planned for importing data from eve-central of course eve-metrics would have been better but it is closing down, so I suggest you keep your eyes on : http://eve-marketdata.com/ it is becoming the new eve-metrics.com. Of course it is just a suggestion.
Again i luv your app but i gotz some questions.
I keep getting this error when i update everything :
Updating player transactions (API)…
Error 101: wallet Exhasued retry after ….blahblah
Whatis that all about?
And 1 last thing, I do not understand selfcost? How can i see the profit i make, can I put in somewhere a field to tell it for how much I am going to sell the stuff I am buying? Or does it get it from the transactions?
Oh and i had another suggestion. People might find it annoying to get and export the market stuff so why not use the autom. market browser that comes with eve-metrics or eve-marketdata ? You just put it on in your IGB and it exports them. Just a tip (and perhaps you can incorrpurate that into your app
About the problem: try to turn off other applications which donloads your transactions via API. Because transactions, journal and orders can be obtained once per hour.
Программа отличная. Я просмотрел очень много торговых инструментов, ментат – лучший. Не бросай программу, она нужна многим.
Мои пожелания:
- возможность скрывать основные вкладки
- программа должна запоминать отрегулированную ширину столбцов в таблицах
- возможность отрегулировать высоту окон во вкладке “рынок” – регионы, систему, станции
- фильтр должен быть всегда включен с последними настройками (без раскрытия панели настроек)
- возможность создавать папки с товарами на вкладке “рынок” (как в квикбаре в самой игре)
- возможность менять местами столбцы во всех вкладках (с сохранением настроек)
yo, i got few questions:
what is market browser ghud for and how do u use it? (guide pls)
whats ‘self cost’?.. i have no clue whats that supposed to mean..
what is it ghud for? how to use? can it tell me my daily profits? (guide pls)
can i figure out my daily profits with this tool at all?
i mean.. profit is all i wanna know.. and i cant find it..
@pekmez
Hello,
To use the market browser you should browse market for different goods in the game and then import to EVE Mentat using cache import (see button on toolbar at the Market Browser tab). Then you will be able to see the market there, compare prices in different locations, find profitable orders.
Self cost – it’s cost of goods for you. Used to calculate profit rate of your trade orders. Now can be set manually (or manually with selected buy transactions). In the future automatic self cost calculation will be implemented.
Currently there is no daily profit indicator, just overall profit for all or selected trade orders.
Of guides and videos… I’m going to create wiki help and more video guides soon.
Hi i tried to start trading with eve mentat and i followed the video. But when i want to import the cache i got this message
[error] Updating market orders (cache)…
[info] Importing from client at ‘C:\Spiele\Eve’…
[warning] Error calling cache import tool. Code: -1073741819
[error] Cache import failed
and i got the message from windows that the evemarketordersfromcahe.exe doesn’t work.
Thanks for helping and excuse the double post i unwittingly pressed the tab-botton.
Actually if my buy orders are closed or i delete them they will not shown as this. In an old version they were still there until I import a new image of my orders… does it happen because of the static database issue? Sry for my english
Thart : @devfrag
Strange… Could you send me your database for investigation?
Well, I’ve tried to reproduce this issue for the last couple of days with no luck. It it comes up again I’ll backup the database and send it to you right away. I’ll end this comment with a question. How long to is the order history available?
Those orders red with cross means I was outbidded by my competitors, however my competitors range are only the station and I am the whole region. So they are not my competitors.
Id like to get those red notifications only when someone that is buying out of the same range as me (region) outbidded me.
Is this possible? Or can you make it possible somehow? ^^
Hes not my competitor because hes buying ONLY in that single station, while Im buying from the entire region. Hes my competitor in that single station.
Id like to get the red notifications IF someone buying that item with the same range as me (region) would outbidded me.
Example: You place a buy order with the range of REGION of 100isks, and I place a buy order with the range of REGION of 90isks, then I would get a red notification.
But If you place a buy order with the range of station of 100isks, and I place a buy order with the range of REGION of 90 isks, then I would NOT get a red notification.
You are buying from the station, while I am buying from the entire region. Prices will be different. They can never be considered my direct competitors.
If I am buying with the range of REGION, then my competitors are the ones buying with the range of REGION as well, and not the ones buying from one single station.
Hes not my competitor because hes buying ONLY in that single station, while Im buying from the entire region. Hes my competitor in that single station.
He doesn’t cover all your area of interest but he is competitor anyway.
You are not right in general, but I see the usefull option for some players in your words: in the future partially overbid orders will be marked with a special color (orange for instance). I’ve just added this task into my database.
I’m missing a report like window like in WalletAware. This report shows is grouping transactions for items filtered by a time range. This is useful for reaction pos owners with different reactions.
I addition I propose a modification of the transactionlist. It should be possible to make a group of items to get only the transactions for this group. Especially for POS owners (inventions, reaction) this would be awesome.
@Ada
I have an idea to implement extended (and saveable) filters for transactions and journal, and I think it’s possible to extend the idea with your request.
I made a little Python software to get a fast report for the data in the 2 database files. The static DB is attached. The SQL strings are (not exact)
Example filter 1 to get just the numbers for the important wares:
SELECT
transactions.typeID,
typeName,
SUM(price*quantity)*(CASE WHEN transactionType=”buy” THEN -1 ELSE 1) AS “cost”
FROM transactions
JOIN invTypes ON transactions.typeID=invTypes.typeID
WHERE ignored=0 AND transactions.typeID IN (44,3434,2344)
GROUP BY transactions.typeID
Example filter 2 to get the profit for the important wares:
SELECT
SUM(price*quantity*(CASE WHEN transactionType=”buy” THEN -1 ELSE 1)) AS “profit”
FROM transactions
WHERE ignored=0 AND transactions.typeID IN (44,3434,2344)
I’m having issues with the importer, it correctly imports ~80% of all orders I cache through the IGB scanner, however there is always at least 1 order that it refuses to scan.
I’ve tried switching the scan time to 10 seconds nad that didn’t help.
I’ve seen comments dating back to 2009 that eve-central support is planned, but so far doesn’t exist. I’m not a programmer but regularly use the Eve-Central API system to retrieve data for my spreadsheets and it’s extremely easy/useful. If I might ask, what’s the barrier?
Just out of curiosity, I don’t mean to be pushy or rude.
hello,
i have a question regarding self cost.
When i buy the same item on different location i have different costs for the items.
When im now manuelly setting a price its the same for all the items.
Can i somehow link the transaction direct or enter a different price for the same item? mb with the transaction id?
thx for the help
@Nicolai Kapersky
No, but you can set self cost to weighted average value from desired transactions.
Just select needed transactions, right click on selection, “Set multiple costs…”.
Hi, I can see one of the features is “smart filter” for Market Browser, but I only have the simple filter available? The one that has max/min price and volume.
Where is the smart filter where I can enter arguments to search for very specific conditions?
Can you make a notify option similar to EVEMon has.
Example…when somebody beats your market price…notify the player with a flash from the windows tray…EVEMON does this with a popup that alerts me when I need a clone upgrade or an empty skill tray….etc etc.
I havnt gotten too much into this program so hopefully this isnt a feature that I dont know about. apologies if I have missed that option.
@Thart
Well I don’t know how you feel about something like “premium” features in your account, where if people wanted this feature they’d have to donate ISK to you.
But anyway, one good reason is that Eve Mentant will be the only program of it’s kind that has something like this. So many programs like this are out there, yet the user still has to trawl through a large amount of data looking for lucrative deals.
Every time it’s the same… check margin, look up trade volume, look up order age (optional depending on how you like your competition). Over and over again. I’m sure this process can be automated somehow but I’ve yet to see any program that does that.
@Kyle
Actually I didn’t mean donation. I was about to tell me actual case when you need smart filtering in market. Just tell your “customer’s story”, examples of filters you need, etc. Send it directly to me if you don’t want to publish this information.
@C.Oph
There are several problems with such automation. One of them – fact that different APIs has different cache time. This will cause to temporary data inconsistancy when all kind of data will be imported automatically.
From the another side, this automation will advance EVE Mentat closer to trade bot’s. This is totally unacceptable for EVE Mentat due to its EULA.
I don’t think there’s anything to hide, really. Most trading guides out there already spell out what to look for anyway. And like I mentioned above it’s just so tedious to keep doing the same manual calculations and comparisons on potential items over and over again.
To be more specific, say I want to filter to be able to see
1. Items with a specific profit margin (let’s say 10%).
2. Items with a high volume. Now, volume of units itself I don’t think is a very useful metric, but if this can be filtered by volume in terms of isk moved, that’d be much more useful. So in this example, let’s say I’m looking for an item with 1bill isk movement per day.
3. Items with the top X orders that have a certain age. For example, if I’m looking for an item that has low competition I’d like to see orders that are, say, 2 days old.
So, if it would be possible to combine all this to form the following filter:
Profit Margin > x%, Volume > X isk volume/day, top x orders > 2 days old.
Then this would be so very very useful.
I don’t know, maybe something like this is impossible and that’s why there aren’t any programs out there that can help do this, but I do these calculations and comparisons manually every few days myself, so I think it should be possible to automate the process a little bit somehow.
@Kyle
Most of these parameters can be easily calculated and used in filtering, except for isk movement per day. Because it requires support of market history.
Let me implement filtering, then you can try and request additional columns in market table.
It keeps saying that it needs more information on my market orders because the information is out of date. I’ve been updating the orders and it still says it needs more information. What should I do?
@Thart
Alright sorry. So when I go to character orders, the sell and buy orders in the price column are highlighted in yellow with an hourglass on the side. When I hover over the orders, it says “Price data are too old to generate right status. Please import fresh market data.” So I go into EVE, open the market orders tab and click export. Then when I go back into Mentat and import the orders, it still says under character orders that the price data is too old.
I’ve tried importing all, using the IGB support, updating my api and I still can’t get the price on the orders to update. I’m new to this so I’m not really sure if this is a bug or if I am doing something wrong.
@Joe
In case of file import you should ensure that file import for market is selected as default in preferences or use proper toolbar button (File import). Also note that you should press File import in Market tab, not in Orders.
The same for cache import. And additionally check your cache import settings and read this troubleshooting page.
Also check Preferences / Data age warning section.
I am doing a cache import for this, and I checked all that and it says my orders are out of date, then when I export them from the market browser and import them into the market tab, it says:
“[ok] Updating market orders (cache)…
[info] Importing from client at ‘C:\Program Files (x86)\CCP\EVE’…
[warning] There are no market files for import!
[info] Launch EVE Online and export any orders at Market window.”
Even though I just exported them.
Do I have to use the IGB support to scan the orders every time I want them updated?
@Thart
I did look at that video and I followed all the steps but after I export from the market tab it still says there are no market files for import.
I can’t figure ouut how to empty the eve cache or delete the machonet. Other than that I’ve tried everything on there. Sorry I’m not great with computers and programming.
Find and delete manually MachoNet folder. Usually it is located here – C:\Users\UserName\AppData\Local\CCP\EVE\your_eve_client_location\cache\MachoNet.
Deleting the Machonet folder and emptying the cache didn’t help, I just started using mentat so I might be doing something wrong. I have a couple questions for you:
1.Do I have to use the IGB url every time I want to update my orders? Or is that just the first time I use mentat or every time I go to change my orders. The video was unclear about this.
2.When I go to the IGB support URL, theres an option of how many seconds to spend scanning each item, I put it on 1 second so it would scan quickly, is it possible I need more time to scan?
@Joe
Unfortunately I don’t understand the source of your problem.
The last one idea refers to “Make sure that you don’t ever launch your client with -lua:off command line parameter. Then look for cache folder inside EVE Online client folder and delete it.”
1. Yes, you have to scan with IGB every time you want to load into EVE Mentat fresh market information.
2. I do not recommend to set scan time lower than 3 sec. There is a kind of limitation from CCP side and you’ll get temporary JavaScript-ban after 30-50th item in scanning process (page refresh might help in this case).
I’m having an issue in getting the ability to automatically copy a new price that’s lower/higher than a competitor. I’ve got the IGB tool running and when I import, all the stuff that was previously scanned is dumped into the Market Browser successfully. However from there, I can’t seem to get that data pushed over to the Character Orders tab in order to copy a new price. Am I missing a step somewhere?
Hi – I’m having difficulty getting Mentat to import either files or Cache – despite following instructions it’s saying no file / cache data found.
I’m getting the green tick on the relevant screen but my guess is it’s a file location issue. I have a folder called Eve on my C drive which contains all my logs then a folder on D which is the game folder. Mentat won’t let me point to the C Drive folders so do I need to bring the two together or am I missing something more obvious anyone?
Whenever i run the IGB scan and look at EVE Mentat, I don’t get an updated ‘Price Status’. It wont update in the tab. And when it does update, some do and some don’t, it will update and undercut the nearest price, but not the lowest/highest price.
1. Market was correctly scanned with IGB scanner with interval not lower than 3 sec (important).
2. Scanned market data was imported into EVE Mentat with “Market cache import” feature. Also make sure it works for at least few positions.
3. Read this.
4. Make sure your orders (not market, personal) also are up to date (use “API import” or “File import” when you have active cooldown in API).
5. Read this.
1) How can I import web data from different regions into EVE mentat? I tried using ‘web import’ in the ‘marketbrowser’, but the ‘regions’ section in the ‘marketbrowser’ tab wont update. It only shows the regions where I’m currently in. Is there a way to review web data (prices) in the program?
2) In the ‘character orders’ section, there is a column called ‘profit per item’. How does this work? I figured it would compare your buy order price with your sell order price, and from there calculate the profit. But it seems it doesn’t work like that. My ‘profit per item’ value is the very same value as my sell order.
Thanks for your quick respons and all the help. Its highly appreciated.
Hey, just curious. My orders are mostly “Data too old”. They don’t update when the others do and the orders are not older than 6-7 hours. Is there a simple answer to why this is happening?
if I’m using region buy orders, i’m not interested in outbidding main stations, i’m looking for cheap deals in remote parts of the region where trade is in short supply.
atm i can only bid at the max bid price, which is completely missing out a whole trading style.
will this be possible, anytime soon ?
10bil in my pocket for you if you can add this feature asap please
Is there a way to set minimum sale/max buy prices based on the profit from reprocessing items? Or, if I set my refining skills, can Eve Mentat show the expected profit from refining an item?
I just installed EVE Mentat on my friend’s PC. I pretty much got everything to work except for the IGB scanner – it doesn’t open the items from the orders. Yet cache import (if you manually open the items) and file import (if you export the orders to files) both work. Any ideas what could be causing this ? I’ve followed every step apart from deleting the cache and deleting that subfolder in the cache.
Quick question regarding Set Cost.
Is there a way to set the cost of the item by importing jita buy / sell values for all active orders? I’m currently doing this manually by copying the jita buy prices but if that is how one acquires goods to sell could this not be a option for setting the cost?
I have several accounts, with each account having several alts. I want to use only one client, and check the market for each character (So mentat would only point to one eve folder). Would this work? Or do I need to have a client for each account and have mentat point to each eve folder
I’m havent Corporate API, and cant to make it because I’m just member of corporation. In any case, me dont need this corpAPIkey.
But on every import of data EVEMentat saying me about the error. In Preferences I did disable ‘Import corporation members’, but still the error. How disable this annoyance?
[ok] [API] Character sheet
[error] [API] Corporate orders: Failed
[error] Authentication error: Key ID and/or Verification Code are missing for this character
I’m having some issues with the Market cache not updating character transactions. I have been following some of your troubleshooting but without success. The error is 1001: Cache is invalid.
Hi, is there a way to have it import the market cache automatically every say.. 30 seconds?
I’ve got the IGB page looping over the items infinitely so I don’t have to keep clicking the button. All I need now is the automatic cache importing so that I don’t have to switch tab > click button > switch tab again.
Got it to load successfully (on Vista had to Run As Administrator) and it imported some market reports. Great! But I see here that there is a Windows app for it where various things can be done. Er… how? The IGB part works great but how do I access the rest of it?
@Krystel Amkalai
Please, explain which features do you mean?
Hi.
I don’t undertand how the “market” tab works.
I got the transactions, orders… by the API, but there’s still nothing in this “market” tab.
What did I do wrong?
@Jimky
Unfortunately, there are no ways to import market via API.
Use file or cache import to fill up EVE Mentat’s market browser with data: view market data in game, than click “Cache import” button in market.
@Thart
Thanks, I’ll try tonight
Hey,
Is it possible to port my manual changes of the “cost price” (under the tab characters orders) from an older version to a newer version?
Thanks
@Sam
Never mind, found it!
Would it be possible to import eve-central dump csv files?
I’ve planned to import data from EVE-Central in future.
Hey, thnx for this lovely app
Still figuring it out 
I see you planned for importing data from eve-central of course eve-metrics would have been better but it is closing down, so I suggest you keep your eyes on : http://eve-marketdata.com/ it is becoming the new eve-metrics.com. Of course it is just a suggestion.
Again i luv your app but i gotz some questions.
I keep getting this error when i update everything :
Updating player transactions (API)…
Error 101: wallet Exhasued retry after ….blahblah
Whatis that all about?
And 1 last thing, I do not understand selfcost? How can i see the profit i make, can I put in somewhere a field to tell it for how much I am going to sell the stuff I am buying? Or does it get it from the transactions?
Thnx:) Luv yer app:)
Oh and i had another suggestion. People might find it annoying to get and export the market stuff so why not use the autom. market browser that comes with eve-metrics or eve-marketdata ? You just put it on in your IGB and it exports them. Just a tip (and perhaps you can incorrpurate that into your app
Actually it doesnt export just views them so you can then use the chache import function and its all good!
@Freezo
Thank you for suggestions.
About the problem: try to turn off other applications which donloads your transactions via API. Because transactions, journal and orders can be obtained once per hour.
I want this to show me when I am outbid on buy orders, but I don’t see how…
@Asmo
Try new alpha release.
How often / or when does the delta collumn update in the sell orders overview of character orders?
@SirHarryPierce
Every time you update order information via API or via file.
Delta values are calculated between old and new values.
Ok, would it be possible to have that collumn show a default timeinterval, like last 24/48/72 hrs?… thx.
@SirHarryPierce
I’ve added proper task for 1.2.x development.
Thanks for suggestion.
grt! thx.
При попытке импортировать рыночные логи выдается ошибка There are no market files to import! На предыдущем стабильном релизе все было в порядке.
@Bud
Изменения в клиенте EVE Online сломали файловый импорт. Ведутся работы.
Программа отличная. Я просмотрел очень много торговых инструментов, ментат – лучший. Не бросай программу, она нужна многим.
Мои пожелания:
- возможность скрывать основные вкладки
- программа должна запоминать отрегулированную ширину столбцов в таблицах
- возможность отрегулировать высоту окон во вкладке “рынок” – регионы, систему, станции
- фильтр должен быть всегда включен с последними настройками (без раскрытия панели настроек)
- возможность создавать папки с товарами на вкладке “рынок” (как в квикбаре в самой игре)
- возможность менять местами столбцы во всех вкладках (с сохранением настроек)
@Bud
Спасибо, большинство из вышеприведенного уже запланировано. Но пару идей записал.
yo, i got few questions:
what is market browser ghud for and how do u use it? (guide pls)
whats ‘self cost’?.. i have no clue whats that supposed to mean..
what is it ghud for? how to use? can it tell me my daily profits? (guide pls)
can i figure out my daily profits with this tool at all?
i mean.. profit is all i wanna know.. and i cant find it..
the ‘overview’ video is no big help..
@pekmez
Hello,
To use the market browser you should browse market for different goods in the game and then import to EVE Mentat using cache import (see button on toolbar at the Market Browser tab). Then you will be able to see the market there, compare prices in different locations, find profitable orders.
Self cost – it’s cost of goods for you. Used to calculate profit rate of your trade orders. Now can be set manually (or manually with selected buy transactions). In the future automatic self cost calculation will be implemented.
Currently there is no daily profit indicator, just overall profit for all or selected trade orders.
Of guides and videos… I’m going to create wiki help and more video guides soon.
Hey Thart,
My anti-virus (Norton) is picking up a keylogger. Is there a purpose for this function? How might I address this and still keep my anti-virus running?
Thanks,
G
@Granix
EVE Mentat has no keyloggers and other malware code inside. It can be Norton’s false positive.
Did you download EVE Mentat from the official web site?
Which module is regonized as keylogger?
Could you test it on VirusTotal service?
Hi i tried to start trading with eve mentat and i followed the video. But when i want to import the cache i got this message
[error] Updating market orders (cache)…
[info] Importing from client at ‘C:\Spiele\Eve’…
[warning] Error calling cache import tool. Code: -1073741819
[error] Cache import failed
and i got the message from windows that the evemarketordersfromcahe.exe doesn’t work.
Thanks for helping and excuse the double post i unwittingly pressed the tab-botton.
@JobZt
Did you try this?
first of all: great app! love the look & feel! but is there any way to import the wallet data like from the beginning of time?
@derps
No, maximally up to one month. It’s API restriction.
Actually if my buy orders are closed or i delete them they will not shown as this. In an old version they were still there until I import a new image of my orders… does it happen because of the static database issue? Sry for my english
@Sunny
Please write me e-mail with additional information including item types you trade and screenshots. It can be a bug and I’m going to catch it.
My corporate order history is showing my personal sales with 1.1.24. Any ideas?
@devfrag
Strange… Could you send me your database for investigation?
Well, I’ve tried to reproduce this issue for the last couple of days with no luck. It it comes up again I’ll backup the database and send it to you right away. I’ll end this comment with a question. How long to is the order history available?
It’d be nice for a csv export of the journal / transactions that have been selected
@Emma
Yes, planned
Hi, how can you set the range for REGION when it tells shows your competitors in one item?
Id like to set my competitors those who are buying out of the entire region, and NOT those who buy out of the station.
@inuke
Hi,
Try this test build. It contains correct price status calculation for buy orders based on real distance and order’s range.
How can I set the RANGE of my competitors??
@inuke
There is no range option for buy orders, because EVE Mentat automatically takes into account your and your rival’s buy order range.
See this: http://i.imgur.com/nGkOB.png
Those orders red with cross means I was outbidded by my competitors, however my competitors range are only the station and I am the whole region. So they are not my competitors.
Id like to get those red notifications only when someone that is buying out of the same range as me (region) outbidded me.
Is this possible? Or can you make it possible somehow? ^^
Thanks so much in advance.
@inuke
If your order’s range is region then any buy order at any station with any range is your competitor.
Competition equation is: your_range + other’s_range >= distance_between_stations (“true” means that your orders is overbid by other’s order).
This doesn’t make sense.
@Thart
Hes not my competitor because hes buying ONLY in that single station, while Im buying from the entire region. Hes my competitor in that single station.
Id like to get the red notifications IF someone buying that item with the same range as me (region) would outbidded me.
Example: You place a buy order with the range of REGION of 100isks, and I place a buy order with the range of REGION of 90isks, then I would get a red notification.
But If you place a buy order with the range of station of 100isks, and I place a buy order with the range of REGION of 90 isks, then I would NOT get a red notification.
You are buying from the station, while I am buying from the entire region. Prices will be different. They can never be considered my direct competitors.
If I am buying with the range of REGION, then my competitors are the ones buying with the range of REGION as well, and not the ones buying from one single station.
See here: http://i.imgur.com/JQBPE.png
Also Thart, an out of topic question ;p
Is it possible to that IGB tool to import the entire market? Or lets say items in the quickbar?
Instead of only our market orders.
@inuke
All market – of couse no. But I plan extend IGB scanner with different options in the future.
He doesn’t cover all your area of interest but he is competitor anyway.
You are not right in general, but I see the usefull option for some players in your words: in the future partially overbid orders will be marked with a special color (orange for instance). I’ve just added this task into my database.
AWEseom XD That will work perfectly, as long as we can tell which orders we need to update
Thanks thart
Why are you doing this? Why are you sharing and maintaining such a software for free?
@me
Hobby, experience, fun.
I’m missing a report like window like in WalletAware. This report shows is grouping transactions for items filtered by a time range. This is useful for reaction pos owners with different reactions.
I addition I propose a modification of the transactionlist. It should be possible to make a group of items to get only the transactions for this group. Especially for POS owners (inventions, reaction) this would be awesome.
@Ada
I have an idea to implement extended (and saveable) filters for transactions and journal, and I think it’s possible to extend the idea with your request.
I made a little Python software to get a fast report for the data in the 2 database files. The static DB is attached. The SQL strings are (not exact)
Example filter 1 to get just the numbers for the important wares:
SELECT
transactions.typeID,
typeName,
SUM(price*quantity)*(CASE WHEN transactionType=”buy” THEN -1 ELSE 1) AS “cost”
FROM transactions
JOIN invTypes ON transactions.typeID=invTypes.typeID
WHERE ignored=0 AND transactions.typeID IN (44,3434,2344)
GROUP BY transactions.typeID
Example filter 2 to get the profit for the important wares:
SELECT
SUM(price*quantity*(CASE WHEN transactionType=”buy” THEN -1 ELSE 1)) AS “profit”
FROM transactions
WHERE ignored=0 AND transactions.typeID IN (44,3434,2344)
Hi
how do i import data from evecentral?
@Nokin Niam
It’s impossible at the moment. But feature already planned.
@Thart
Ok when does it come? it will de the most used tool for me and for others too!
I’m having issues with the importer, it correctly imports ~80% of all orders I cache through the IGB scanner, however there is always at least 1 order that it refuses to scan.
I’ve tried switching the scan time to 10 seconds nad that didn’t help.
@Kulanah
Market cache import FAQ
@Thart
I’ve seen comments dating back to 2009 that eve-central support is planned, but so far doesn’t exist. I’m not a programmer but regularly use the Eve-Central API system to retrieve data for my spreadsheets and it’s extremely easy/useful. If I might ask, what’s the barrier?
Just out of curiosity, I don’t mean to be pushy or rude.
@Killadicter
The main barrier – a lot of different tasks.
Nevertheless, Importom from web services (EVE-Cental, EVEMarketeer, EVEMarketdata) is already implemented in EVE Mentat 1.2.x prototype.
Join EVE Mentat Google group if you wish to try the prototype.
hello,
i have a question regarding self cost.
When i buy the same item on different location i have different costs for the items.
When im now manuelly setting a price its the same for all the items.
Can i somehow link the transaction direct or enter a different price for the same item? mb with the transaction id?
thx for the help
@Nicolai Kapersky
No, but you can set self cost to weighted average value from desired transactions.
Just select needed transactions, right click on selection, “Set multiple costs…”.
ah okay that helps!
is there also some profit screening with fees taxes and profits and all?
@Nicolai Kapersky
To be implemented soon.
mkay looking forward to that
thx anyway for the great tool
@Nicolai Kapersky
Thanks!
BTW, I recommend you to participate in EVE Mentat 1.2 open beta test.
Hi, I can see one of the features is “smart filter” for Market Browser, but I only have the simple filter available? The one that has max/min price and volume.
Where is the smart filter where I can enter arguments to search for very specific conditions?
@Kyle
In EVE Mentat 1.2 smart filtering is implemented only for orders/journal/transactions.
But I can implement it for market if you convince me
Can you make a notify option similar to EVEMon has.
Example…when somebody beats your market price…notify the player with a flash from the windows tray…EVEMON does this with a popup that alerts me when I need a clone upgrade or an empty skill tray….etc etc.
I havnt gotten too much into this program so hopefully this isnt a feature that I dont know about. apologies if I have missed that option.
thx…great program so far
@Thart
Well I don’t know how you feel about something like “premium” features in your account, where if people wanted this feature they’d have to donate ISK to you.
But anyway, one good reason is that Eve Mentant will be the only program of it’s kind that has something like this. So many programs like this are out there, yet the user still has to trawl through a large amount of data looking for lucrative deals.
Every time it’s the same… check margin, look up trade volume, look up order age (optional depending on how you like your competition). Over and over again. I’m sure this process can be automated somehow but I’ve yet to see any program that does that.
@Kyle
Actually I didn’t mean donation. I was about to tell me actual case when you need smart filtering in market. Just tell your “customer’s story”, examples of filters you need, etc. Send it directly to me if you don’t want to publish this information.
@C.Oph
There are several problems with such automation. One of them – fact that different APIs has different cache time. This will cause to temporary data inconsistancy when all kind of data will be imported automatically.
From the another side, this automation will advance EVE Mentat closer to trade bot’s. This is totally unacceptable for EVE Mentat due to its EULA.
@Thart
Hey Thart,
I don’t think there’s anything to hide, really. Most trading guides out there already spell out what to look for anyway. And like I mentioned above it’s just so tedious to keep doing the same manual calculations and comparisons on potential items over and over again.
To be more specific, say I want to filter to be able to see
1. Items with a specific profit margin (let’s say 10%).
2. Items with a high volume. Now, volume of units itself I don’t think is a very useful metric, but if this can be filtered by volume in terms of isk moved, that’d be much more useful. So in this example, let’s say I’m looking for an item with 1bill isk movement per day.
3. Items with the top X orders that have a certain age. For example, if I’m looking for an item that has low competition I’d like to see orders that are, say, 2 days old.
So, if it would be possible to combine all this to form the following filter:
Profit Margin > x%, Volume > X isk volume/day, top x orders > 2 days old.
Then this would be so very very useful.
I don’t know, maybe something like this is impossible and that’s why there aren’t any programs out there that can help do this, but I do these calculations and comparisons manually every few days myself, so I think it should be possible to automate the process a little bit somehow.
@Kyle
Most of these parameters can be easily calculated and used in filtering, except for isk movement per day. Because it requires support of market history.
Let me implement filtering, then you can try and request additional columns in market table.
Thanks Thart
Looking forward to trying it out.
when i load journal i only get transaction for 1 month. how to make mentat grab all entries? in-game i can look back into november 2011
@wan
EVE API limitation.
It keeps saying that it needs more information on my market orders because the information is out of date. I’ve been updating the orders and it still says it needs more information. What should I do?
@Joe
First of all describe your problem in details (and with screenshots).
@Thart
Alright sorry. So when I go to character orders, the sell and buy orders in the price column are highlighted in yellow with an hourglass on the side. When I hover over the orders, it says “Price data are too old to generate right status. Please import fresh market data.” So I go into EVE, open the market orders tab and click export. Then when I go back into Mentat and import the orders, it still says under character orders that the price data is too old.
I’ve tried importing all, using the IGB support, updating my api and I still can’t get the price on the orders to update. I’m new to this so I’m not really sure if this is a bug or if I am doing something wrong.
@Joe
In case of file import you should ensure that file import for market is selected as default in preferences or use proper toolbar button (File import). Also note that you should press File import in Market tab, not in Orders.
The same for cache import. And additionally check your cache import settings and read this troubleshooting page.
Also check Preferences / Data age warning section.
@Thart
I am doing a cache import for this, and I checked all that and it says my orders are out of date, then when I export them from the market browser and import them into the market tab, it says:
“[ok] Updating market orders (cache)…
[info] Importing from client at ‘C:\Program Files (x86)\CCP\EVE’…
[warning] There are no market files for import!
[info] Launch EVE Online and export any orders at Market window.”
Even though I just exported them.
Do I have to use the IGB support to scan the orders every time I want them updated?
Looks like you are talking about different things…
Just look at this video…
@Thart
I did look at that video and I followed all the steps but after I export from the market tab it still says there are no market files for import.
This one?
@Thart
I can’t figure ouut how to empty the eve cache or delete the machonet. Other than that I’ve tried everything on there. Sorry I’m not great with computers and programming.
@Thart
Deleting the Machonet folder and emptying the cache didn’t help, I just started using mentat so I might be doing something wrong. I have a couple questions for you:
1.Do I have to use the IGB url every time I want to update my orders? Or is that just the first time I use mentat or every time I go to change my orders. The video was unclear about this.
2.When I go to the IGB support URL, theres an option of how many seconds to spend scanning each item, I put it on 1 second so it would scan quickly, is it possible I need more time to scan?
@Joe
Unfortunately I don’t understand the source of your problem.
The last one idea refers to “Make sure that you don’t ever launch your client with -lua:off command line parameter. Then look for cache folder inside EVE Online client folder and delete it.”
1. Yes, you have to scan with IGB every time you want to load into EVE Mentat fresh market information.
2. I do not recommend to set scan time lower than 3 sec. There is a kind of limitation from CCP side and you’ll get temporary JavaScript-ban after 30-50th item in scanning process (page refresh might help in this case).
Is there a way to adjust the balance graph so it starts at 0 isk?
I’m having an issue in getting the ability to automatically copy a new price that’s lower/higher than a competitor. I’ve got the IGB tool running and when I import, all the stuff that was previously scanned is dumped into the Market Browser successfully. However from there, I can’t seem to get that data pushed over to the Character Orders tab in order to copy a new price. Am I missing a step somewhere?
@Stu
Currently no.
@KT
Did you really update charater orders?
This can be done via API or file. But API import has a hour cooldown.
Hi – I’m having difficulty getting Mentat to import either files or Cache – despite following instructions it’s saying no file / cache data found.
I’m getting the green tick on the relevant screen but my guess is it’s a file location issue. I have a folder called Eve on my C drive which contains all my logs then a folder on D which is the game folder. Mentat won’t let me point to the C Drive folders so do I need to bring the two together or am I missing something more obvious anyone?
@DB
EVE Mentat uses standard location to import files exported from EVE – it’s Documents folder.
Cache location can be changed in preferences.
Thanks Thart – when I point it at the Eve Docs folder it gives me the red cross not the tick – sorry I’m not IT proficient
Hiya
Whenever i run the IGB scan and look at EVE Mentat, I don’t get an updated ‘Price Status’. It wont update in the tab. And when it does update, some do and some don’t, it will update and undercut the nearest price, but not the lowest/highest price.
Any tips?
@Saint
Please make sure next things:
1. Market was correctly scanned with IGB scanner with interval not lower than 3 sec (important).
2. Scanned market data was imported into EVE Mentat with “Market cache import” feature. Also make sure it works for at least few positions.
3. Read this.
4. Make sure your orders (not market, personal) also are up to date (use “API import” or “File import” when you have active cooldown in API).
5. Read this.
Thanks, got it to work.
I have two more questions though:
1) How can I import web data from different regions into EVE mentat? I tried using ‘web import’ in the ‘marketbrowser’, but the ‘regions’ section in the ‘marketbrowser’ tab wont update. It only shows the regions where I’m currently in. Is there a way to review web data (prices) in the program?
2) In the ‘character orders’ section, there is a column called ‘profit per item’. How does this work? I figured it would compare your buy order price with your sell order price, and from there calculate the profit. But it seems it doesn’t work like that. My ‘profit per item’ value is the very same value as my sell order.
Thanks for your quick respons and all the help. Its highly appreciated.
Will this work on OS X iMac?
Hey, just curious. My orders are mostly “Data too old”. They don’t update when the others do and the orders are not older than 6-7 hours. Is there a simple answer to why this is happening?
@Saint
1. With web import it’s possible to update market information in different regions only one by one. Turn on “Quick import panel” and try.
2. Profit-related calculations are based on self costs which are manually defined.
@Tosub
No I think.
@Sammy
Do you mean character or market orders?
@Thart
I mean for character orders.
P.S Regardless. This program is a life safer.
@Sammy
Make sure you have configured to use API import by default for your orders.
does this work on mac with os X?
Please allow us to limit outbid by order range.
if I’m using region buy orders, i’m not interested in outbidding main stations, i’m looking for cheap deals in remote parts of the region where trade is in short supply.
atm i can only bid at the max bid price, which is completely missing out a whole trading style.
will this be possible, anytime soon ?
10bil in my pocket for you if you can add this feature asap please
@Rita Jita
Yes, it’s possible, I think.
Could you contact me directly via e-mail? I have to ask you few things needed to start.
I don’t know why but the Deviation button is disabled anyoen know what could be the problem?
same as Jobl0wn. its possible im just a fail
@Jobl0wn
@janos
Guys make a screenshot of entire tab please.
Is there a way to set minimum sale/max buy prices based on the profit from reprocessing items? Or, if I set my refining skills, can Eve Mentat show the expected profit from refining an item?
@christophe
No, at the moment.
I just installed EVE Mentat on my friend’s PC. I pretty much got everything to work except for the IGB scanner – it doesn’t open the items from the orders. Yet cache import (if you manually open the items) and file import (if you export the orders to files) both work. Any ideas what could be causing this ? I’ve followed every step apart from deleting the cache and deleting that subfolder in the cache.
@devyz
Try this and then post bug report with detailed description and log file.
Quick question regarding Set Cost.
Is there a way to set the cost of the item by importing jita buy / sell values for all active orders? I’m currently doing this manually by copying the jita buy prices but if that is how one acquires goods to sell could this not be a option for setting the cost?
Love your addon !
@Levonticus
Not possible at the moment, but planned.
Thart
I have several accounts, with each account having several alts. I want to use only one client, and check the market for each character (So mentat would only point to one eve folder). Would this work? Or do I need to have a client for each account and have mentat point to each eve folder
@Tread
It’s ok. Market is not character dependent.
I’m havent Corporate API, and cant to make it because I’m just member of corporation. In any case, me dont need this corpAPIkey.
But on every import of data EVEMentat saying me about the error. In Preferences I did disable ‘Import corporation members’, but still the error. How disable this annoyance?
[ok] [API] Character sheet
[error] [API] Corporate orders: Failed
[error] Authentication error: Key ID and/or Verification Code are missing for this character
Hello
I’m having some issues with the Market cache not updating character transactions. I have been following some of your troubleshooting but without success. The error is 1001: Cache is invalid.
Any idea how to fix this?
@BP
It’s a server side issue. Waiting for actions from CCP.
Hi, is there a way to have it import the market cache automatically every say.. 30 seconds?
I’ve got the IGB page looping over the items infinitely so I don’t have to keep clicking the button. All I need now is the automatic cache importing so that I don’t have to switch tab > click button > switch tab again.
@Thart
hi. sorry for the delay been away from eve. problem still there. how do you want this screenshot?