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.
12Next page
 

Eve-spreadsheet - A new way to find items to trade

Author
Enyah Al'ktar
Birds of Prey Inc
#1 - 2015-05-18 19:52:53 UTC  |  Edited by: Enyah Al'ktar
Hello,

I would like to present you a new Eve Online web tool designed to work like a simple trading spreadsheet without limitations of excel or googlespreadsheet and with a better ui (i don't like excel ui).
It's not an advanced spreadsheet and it doesn't analyse the market for you.

It can help you to keep an eyes on different items or find new opportunity.

http://www.eve-spreadsheet.com/


Features :

Search items :

  • Find items by categories and stations
  • Display basic informations (buy price, sell price, volume) and profit based on your skills and standings
  • Display history price and transactions based on ingame data
  • Refine the search with differents filters (profit, price, transactions)



Create favorites :

  • Create favorites folder and add new items to have a quick look on it



And more :

  • Volume of transactions cache every 24h
  • Price cached automatically pull for Jita, Amarr and Dodixie
  • Available in English and French



Price :

The tool is based on subscription but you have 7 free days of standard access.


  • Standard : 30m/Month
  • Premium : 70m/Month



The standard package is recommended if you are a new trader, if you are looking for a simple spreadsheet or if you don't need more than 2 characters on the tool.

The premium package allow you to have more characters and favorites and grant you access to futur features.
I recommend it if you usually use multiples characters to trade, if you make inter hub trading with multiples characters or if you just want to help in the developpement.


If you have any questions, any issues, any feed back or more; feel free to contact me ingame with mail/convo or here.

ps : I'm not a native english speaker, sorry for mistakes in this post. If you want share some corrections, you are welcome.
Princess Kyky
Keepers of Hali
#2 - 2015-05-18 20:54:04 UTC
First glances it looks good, how often are the prices updated?
Enyah Al'ktar
Birds of Prey Inc
#3 - 2015-05-18 21:18:02 UTC
Princess Kyky wrote:
First glances it looks good, how often are the prices updated?



Price for Jita, Amarr and Dodoxie are automatically pull each 30min for now.
Other system are pull by users and cached for 30min
Princess Kyky
Keepers of Hali
#4 - 2015-05-18 21:32:52 UTC
another question, not sure if ive missed this but how much will you be charging for the memberships?
Enyah Al'ktar
Birds of Prey Inc
#5 - 2015-07-02 21:31:03 UTC
I updated the site

  1. Minor

    • Cache volume should be up to date
    • Fix some translation error
    • Correct few design issues


  2. Major

    • New search filters
    • Trading activity of items on market (see below)
    • Add new data on chart (price average and number of orders)




Trading activity of items on markett
Allow user to have a quick look about the activity on an item.
What does it mean ?
It actually works with the number of orders recently update in the last hour and the number of order set on the market of the station. It display if there is high competitiveness or not.
This feature need probably some adjustment

I also decrease the price.

I'm still looking to add new market analysis features (but my knowledge in real economy sucks). If you have idea, feel free to share :)
Ren Oren
Native Freshfood
Minmatar Republic
#6 - 2015-07-04 16:36:06 UTC
Good luck to you
Enyah Al'ktar
Birds of Prey Inc
#7 - 2015-08-03 14:42:00 UTC
Site has been updated.

Only minor correction here

  • Fix translation error (again)
  • Fix name of few items in database
Enyah Al'ktar
Birds of Prey Inc
#8 - 2015-10-09 14:08:17 UTC
It took a while but a new version is out !


  • Favorite now working with crest and pull data each 5 minutes
  • Search items will now display items without profit if there is no value in minimum profit(%) and/or minimum profit(ISK)
  • Search filters data is now correctly save into cookies
  • Fix CSS and HTML issues


Now I'm trying to improve performance of the code, and the ui for a better experience
Dethmourne Silvermane
Silvermane Holdings LTD
#9 - 2015-10-09 21:49:06 UTC  |  Edited by: Dethmourne Silvermane
Okay, so I like this, but is there any way you can add one more column where it takes profit times volume and plugs that number? Bonus points if we can configure some multiplier of this value (double bonus points if your elite sub allows for configuring this multiplier on a per-item basis).

EDIT: to clarify, the multiplier would be expressed as probably a percentage from 0-100 - for example, I might think I can capture 1% of the veldspar market, but 10% of the 425mm compressed coil gun market, and so I'd want to compare my potential profit for trading each against each other. This would also allow filtering out items that I think are never worth trading by saying I'm going to capture 0% of their market - e.g. certain officer mods.

Interested Party (TM)

Enyah Al'ktar
Birds of Prey Inc
#10 - 2015-10-10 15:09:10 UTC
Hum, i think i understood, at least the beginning. To resume (correct me if i'm wrong) :
- You want to see profit * volume for a day
- You want to see how much profit for X % of the volume
- You want to change manually this X %

Crom Domison
Brutor Tribe
Minmatar Republic
#11 - 2015-10-12 07:48:48 UTC  |  Edited by: Crom Domison
Had issues adding my API. Kept saying I should check my access key?

*EDIT: Question - are you able to check the profit margins on more than 1 item at a time? It'd be good to be able to see a lot of items and see which items are best to sell based off what their buy/sell orders are at. I can then find those items in the game and look at their market history to see if they're worth trading
Dethmourne Silvermane
Silvermane Holdings LTD
#12 - 2015-10-12 11:53:55 UTC
Enyah Al'ktar wrote:
Hum, i think i understood, at least the beginning. To resume (correct me if i'm wrong) :
- You want to see profit * volume for a day
- You want to see how much profit for X % of the volume
- You want to change manually this X %



Exactly.

Interested Party (TM)

Enyah Al'ktar
Birds of Prey Inc
#13 - 2015-10-12 13:40:47 UTC
Quote:
Had issues adding my API. Kept saying I should check my access key?


Did you tried with a predefined key?

Quote:
*EDIT: Question - are you able to check the profit margins on more than 1 item at a time? It'd be good to be able to see a lot of items and see which items are best to sell based off what their buy/sell orders are at. I can then find those items in the game and look at their market history to see if they're worth trading


Hum i'm not sure to understand. It's already display a group of items depending on what you choose in the search tab

Quote:
Exactly.


Ok. I will see what i can do about that
Dethmourne Silvermane
Silvermane Holdings LTD
#14 - 2015-10-12 16:55:59 UTC
Enyah Al'ktar wrote:
Quote:
Had issues adding my API. Kept saying I should check my access key?


Did you tried with a predefined key?

Quote:
*EDIT: Question - are you able to check the profit margins on more than 1 item at a time? It'd be good to be able to see a lot of items and see which items are best to sell based off what their buy/sell orders are at. I can then find those items in the game and look at their market history to see if they're worth trading


Hum i'm not sure to understand. It's already display a group of items depending on what you choose in the search tab

Quote:
Exactly.


Ok. I will see what i can do about that



One thing I want to make sure we're clear on is that I'd like to be able to change that X on a per-item basis - in other words, set X to 1% for Tritanium, 5% for Golem, 10% for Large Shield Extender II, etc.

It's okay if that's not possible, but if it is that'd be an amazing add.

Interested Party (TM)

Enyah Al'ktar
Birds of Prey Inc
#15 - 2015-10-18 22:44:39 UTC  |  Edited by: Enyah Al'ktar
A new version (1.2.0) is out.

News features has been added so it can be a little buggy. I'm sorry about that. If you encounter any problem, report it to me so i can correct it asap Big smile

Fix :

  • HTML, CSS, and Javascript fix (yeah has always)
  • Pulling price data for favorites and activity calculation are now using public crest instead of auth crest as recommended by CCP
  • Users disconnected are now informed with a message
  • Favorite use static data instead of session data to calculate price (not a big difference for you)
  • Add a system to inform users when site is down for maintenance



Basic Features (available for all subscription plan)

  • Add 4 new themes (blue, red, grey and black)
  • You can now add items in your favorites without using the search window :
  • Use the quickbar of the market to do a list, then copy paste it in the form . You can find this form by clicking on "Add new items" when a file is selected (This is the only method which work actually, sorry Sad)


Premium Features (only available for premium subscription)
These features are in test, report all the bug you find so i can fix it

  • You can change price of an item manually by clicking on the field. All other column will be recalculate (profit, profit%, average daily profi)
  • Daily profit are now available :

  • 1) You can use it in the search filters to filter out items
    2) You can see an average daily profit based on the volume trade, this volume can be edited

    Because an image is better to explain something : Example

Enyah Al'ktar
Birds of Prey Inc
#16 - 2015-11-19 13:55:29 UTC
Hello,

The site seem's to have a problem to accept payement.
If you encounter an issue after a payement, feel free to send me a mail ingame with your order key and your username.

I'm working on it, to have it back as soon as possible
Enyah Al'ktar
Birds of Prey Inc
#17 - 2015-11-25 20:06:48 UTC  |  Edited by: Enyah Al'ktar
A new patch is out (1.3.0)

First, i would present my apologize for the long downtime. I had some difficult to resolve some issues :(

Second, the resume. There is not a lot of big features.


  • New feature : You can now make a report with the link in the footer. It also work to report a payement issue, i'll receive all data needed to fix it (i hope Ugh)
  • Change the user panel to display more readable subscriptions informations (include the timer when the api is called to update the subscription)
  • Add promotion code system
  • New administration panel
  • Fix on differents crons
  • Fix Javascript issue


If you encounter any problem, report it to me so i can correct it asap

What next :
- I'm working to add filters in favorites files
- A new way to work with your differents characters
- Migration to a new version of the framework

All of this should come in middle of december Big smile


Known issues :
- You have to disconnect to have your account upgrade properly after a subscription
- You may have an error when trying to load your favorite, for now just refresh the page and it should work
- Display activity of an item can stay stuck on loading
Enyah Al'ktar
Birds of Prey Inc
#18 - 2015-12-11 16:03:54 UTC
I have updated the site with items released with the last patch
Jean Duchesnois
University of Caille
Gallente Federation
#19 - 2015-12-16 06:57:48 UTC
Volume doesn't seems to work for me as "volume" column always shows 0 for any given item. Minimum and maximum transaction a day are not working either, putting anything but 0 in minimal transaction / day resulting in 0 results.
Enyah Al'ktar
Birds of Prey Inc
#20 - 2015-12-16 11:35:41 UTC
http://eve-marketdata.com/ is dead so the spread wasn't able to pull volume correctly.

I have put an old backup volume from 11/12 and disable automatic pull for it, so data will not be erase.
It should work now.

Meanwhile, i'll see if i can contact the owner of eve-marketdata to see if the site will be back shortly or if i need to work on a new way to get volume.

12Next page