v1.5.0 Lots of stuff

Inter-regional price checks

• New sheet that will take in groups of items to compare to the major trade hubs. Don't mess with the filtering, they're broken atm
  

Character active orders

• 2 new sheets that display stats of the character's active orders
• Diff % = difference between your order and the lowest sell/highest buy, Item Margin % = margin of current pricing
• Also highlights your orders in the main market browser
  
  

Quick clipboard copying

• Certain cells and columns will have a fancy highlighted effect denoting that clicking on them will copy their contents
• For cells with ISK, it will copy the undersell price for sell orders, and overbid price for buy orders
  • Needs more working on because the code is flawed, but it works

clipboard.demo.mp4

Major fix

I've finally figured out why the VBA was always so glitchy. I've been using a depreciated library that only works under specific conditions that I can't figure out. It should be fixed with this release (hopefully).

Annoying bug

There's an issue with the Market Browser sheet flickering and it's annoying at best and seizure-inducing at worst. It seems to stop when the sheet is finished with its calculations, but it takes too long to be comfortable. Will work on this next.

Next planned feature will be price alerts.

v1.4.0 Group stats, other major improvements

Biggest addition is the group stats. You can now select entire groups of items and see various stats that I thought were relevant for trading, including volume, ROI, historical trends, and margins.

Also added a slider for price history. Due to excel limitations it's very jank, but it works well for what it is.

At this point, the sheet is a lot more expansive than what I had in mind when I first started this. Not sure where it's going to go, but we'll see. Also not going to bother with sheet/cell protection; if you're using the sheet you're probably smart enough to know what you're doing anyways.

v1.3.1 Price History

When making this sheet I said I couldn't add the price history tab because Eve x Excel did not have a history function. This is no longer the case (🥳). CCP added .MARKET_HISTORY a few weeks ago so I recreated the price history window as best as I could.

It is very rudimentary, showing only the past 4 months of orders and not being able to be moved. I intend to change this in the future, but for now it works pretty well for viewing recent orders.

On my personal version of the sheet, I was toying with the idea of making a price watcher so you could easily see what items to buy and sell, but that might be outside the scope of this project.

v1.2.0 SDE Update improvements, last big update for a while

Big progress in making the sheet much more user-friendly and suitable for long-term usage.

The instructions are now far more simple to follow (with buttons!) and the UI is more dummy-proof in that cells not intended to be interacted with are locked and the math sheets are hidden.

In terms of replicating EVEMarketer, I consider this project 95% finished. At this point, all there is to do are some minor UI and formatting changes, as well as updating invTypes every so often, but the bulk of the math and logic should be stable for the foreseeable future. There's also a lack of interest in this project, so until I see some sudden interest popping up, I might consider sunsetting ExcelMarketer for now. Thanks for checking this out!

Changes:

SDE Import Improvements

• The sheet now has the functionality to update its SDE sheet by checking if invTypes.csv is in the same folder as the sheet
• Added 2 scripts that both do this update: One upon startup, and one upon clicking a button in the instructions sheet
• Updated the instructions tab to reflect this change

Other minor changes

• Fixed skills to allow untrained/level 0 option
• Minor UI changes

v1.1.0 - Proper UI setup

Because Excel sheets are binary files and git can't store incremental changes with them, I'm going to try to do fewer commits from now on because with every commit I make the project gets that much larger.

Changes:

UI Overhaul

• Properish dark mode imitating EVEMarketer and in-game Regional Market window
• Search cell has placeholder "Search" text to make it more intuitive
• Replaced text with Roboto
• Taking out the scrollbar for now because it's a nightmare to work with

Other minor changes:

• Error handling for empty cells
• Expanded order view from 10 -> 13 orders

v1.0.0 - Minimum functioning program

Thingy works! There's a lot of work to be done but right now it does a good job of viewing markets when out-of-game.