Pages: [1] 2 :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Enyah Al'ktar
Birds of Prey Inc
6
|
Posted - 2016.07.14 15:19:12 -
[1] - Quote
Eve-spreadsheet is back! And with a new version, called 2.0 !
What is evespreadsheet ? What is the difference with others spreadsheets ?
Eve-spreadsheet is a tool designed to work like a trading spreadsheet but without the excel ui and the limitation of excel or googlespreadsheet. You can search among all items using differents settings (price, profit, volume, location, characters). You can also create favorites groups, this groups are refresh each 5min when open to give you data up to date (it's using crest, so you may not notice changed each 5min)
Prices for Jita, Amarr and Dodixie are automatically called by the server each 30 minutes. Price in other systems are cached 30minutes after an user request. Volume are cached automatically by the server each day.
What's the big difference between the standard pack and the premium one ?
Premium user can have more characters and favorites groups. They have the ability to interact with price in the result and can set a daily profit based on the volume trade. They also have a filter in their favorites groups.
What happened ?
Eve-spreadsheet is developed with a framework called CakePHP. At first, it was based on CakePHP 2, but framework evolve quickly nowadays. A big update was made on this framework. Eve-spreadsheet was the last of my site still running on the old version of this framework so i decided to upgrade it. But it was harder than expected (Yeah the code wasn't really good). I had to rewrite a huge part of the code to have something better, simpler and easier to maintain.
Now i coming back with a new version of the site and i will be able to add features faster
People who had a subscription during my silence will receive 3 months of premium account
What changed ?
I made some change in the database itself. Your account are safe, but all api keys, characters and favorites have been deleted. Favorites are not link anymore to character but to your account. So the restriction to create a favorite is now for the whole account instead of each characters
Design :
- The site adopt a design which is more flat than the old one
- I will add more theme with different color soon
Features :
- All previous features are still here, some work better so
- I don't use cookie anymore to store your search preference. Instead, you can save them on different profils to apply them to the form. I find it more flexible this way
- Each pages should be independent now. So if you open differents favorites on your browser, each one should pull its own data
- There is a new notification system to display informations i would like to broadcast or relative to your account
More :
- There is probably a lot of bugs i haven't find yet. You can submit them here, by mail, by using the contact form of the site or with the report form
- English isn't my native language so there is probably some weird mistakes everywhere. Feel free to report them so i can fix them
What next ?
Well first, fix all bugs of course. Then add more features. Someone suggested to display more data and will probably work on that. If you have some idea you would like to discuss, i'll glad to have chat with you. For example, "daily profit based on the volume trade" was requested by one of the users |
Reileen Kawahara
Observatory Corporation
51
|
Posted - 2016.07.14 16:05:29 -
[2] - Quote
Quote:CakePHP: the rapid development php framework An Internal Error Has Occurred
That doesnt look good. |
Enyah Al'ktar
Birds of Prey Inc
6
|
Posted - 2016.07.14 16:15:10 -
[3] - Quote
Where did you get this message ? |
Reileen Kawahara
Observatory Corporation
51
|
Posted - 2016.07.15 15:08:32 -
[4] - Quote
When I go to search for a trade. |
Amanda Rekenwhith
Safeties On Red
64
|
Posted - 2016.07.16 11:31:53 -
[5] - Quote
Since the in game browser is going away, your free trial should not require use of it.
For dessert we're offering humble pie. -įWould you like some after you're done eating crow?
|
William Legrand-Marx
Nemesis Ad Astra RUST415
3
|
Posted - 2016.07.16 11:33:48 -
[6] - Quote
Enyah Al'ktar wrote:Where did you get this message ?
Oh spreadsheets, no wonder people are losing interest in the game in 2016.
There is nothing worthy in this world even if others think it is worth something...
|
Enyah Al'ktar
Birds of Prey Inc
6
|
Posted - 2016.07.17 11:37:44 -
[7] - Quote
This tool isn't design to work on the IGB, it's and old technology with a lot of limitation.
The error seem's to be solve, thanks to Reileen Kawahara for her help in the process. I have deployed some fix :
- User can not access search or favorite page without at least 1 character active
- The API key need at least Standings and CharacterSheet checked. This data are used to calcul the broker fee and the sale tax
|
Enyah Al'ktar
Birds of Prey Inc
6
|
Posted - 2016.07.28 08:15:58 -
[8] - Quote
I have deploy a small patch this morning to fix some issues, you can see the change here
In same time, volume is not pull anymore. This is temporary. I'm looking for a new way to pull volume but less intense for the server by avoiding pulling items or regions you don't need. I already have the idea, i just need to develop it |
Enyah Al'ktar
Birds of Prey Inc
8
|
Posted - 2016.08.02 09:45:45 -
[9] - Quote
2.0.2 is out It's fixing the problem with volume. Volume will now be up to date.
What changed? Usually i pulled all volume for all items in all regions each day. But its very stressful for the server. When the full pull occured, the server turn to be really slow and it's not something good. Now, volume for each regions are stored on the server only if one of you is looking for it. It's then refresh each day. If it's not used for few days, the server delete it to prevent useless pull
I'm working now on a new feature to display an average data for buy price/sell price/volume/profit. This was requested by and user |
orionbeta
Romanus Sica
4
|
Posted - 2016.08.11 19:43:38 -
[10] - Quote
Curious if a couple things could be added, changed.
1. Under Search, next to it it says "Use a Profil". Maybe changed to "Use a Profile".
2. Is there anyway a sort button could be used to bring items with the highest margins to the top?
I like this better then Eve Trade master as here you can looking at pretty much a whole group of items instead of being limited at 50 items per trade route. Thanx for a great product.
Fly Safe, Orion |
|
Enyah Al'ktar
Birds of Prey Inc
8
|
Posted - 2016.08.12 13:14:16 -
[11] - Quote
orionbeta wrote:Curious if a couple things could be added, changed.
1. Under Search, next to it it says "Use a Profil". Maybe changed to "Use a Profile".
2. Is there anyway a sort button could be used to bring items with the highest margins to the top?
I like this better then Eve Trade master as here you can looking at pretty much a whole group of items instead of being limited at 50 items per trade route. Thanx for a great product.
Fly Safe, Orion
I'll correct this misspell on the next patch. Yes you can sort items. If you want to sort with the highest margin, click on profit price or profit(%) it will sort the list by profit. You can do the same for the name, buy price, sell price, volume. There will be an icon on the next patch.
|
orionbeta
Romanus Sica
4
|
Posted - 2016.08.12 17:53:51 -
[12] - Quote
Enyah Al'ktar wrote:orionbeta wrote:Curious if a couple things could be added, changed.
1. Under Search, next to it it says "Use a Profil". Maybe changed to "Use a Profile".
2. Is there anyway a sort button could be used to bring items with the highest margins to the top?
I like this better then Eve Trade master as here you can looking at pretty much a whole group of items instead of being limited at 50 items per trade route. Thanx for a great product.
Fly Safe, Orion I'll correct this misspell on the next patch. Yes you can sort items. If you want to sort with the highest margin, click on profit price or profit(%) it will sort the list by profit. You can do the same for the name, buy price, sell price, volume. There will be an icon on the next patch.
AWESOME! Thank you. |
Enyah Al'ktar
Birds of Prey Inc
8
|
Posted - 2016.08.15 12:31:34 -
[13] - Quote
2.0.3 is now deployed
No major change but some fix : - Premium users can sort items by daily profit - Add some icons so you can see how to sort and what - Fix some misspells and design errors - Improve the filter, so the page will no longer reload when you navigate through the items categories
I am still working on the new features but i am still at the beginning
|
Ferrata Askiras
Deep Core Mining Inc. Caldari State
0
|
Posted - 2016.08.16 10:14:55 -
[14] - Quote
No page loads when attempting to find trades. Blank page is on URL /get-items/ |
Enyah Al'ktar
Birds of Prey Inc
8
|
Posted - 2016.08.16 14:17:17 -
[15] - Quote
Fixed, sorry for this little problem |
Enyah Al'ktar
Birds of Prey Inc
8
|
Posted - 2016.09.24 12:27:26 -
[16] - Quote
Updated with the lastest version of the game |
Katte Boldo
The Scope Gallente Federation
0
|
Posted - 2016.09.27 04:57:35 -
[17] - Quote
I love your work. But still no prices for "blueprints"? |
Enyah Al'ktar
Birds of Prey Inc
8
|
Posted - 2016.09.29 07:50:56 -
[18] - Quote
That's sounds weird. Will look at it. |
Enyah Al'ktar
Birds of Prey Inc
8
|
Posted - 2016.10.19 08:52:27 -
[19] - Quote
The site is in maintenance to solve the current problem. Thanks for your patience |
Enyah Al'ktar
Birds of Prey Inc
8
|
Posted - 2016.12.04 13:40:21 -
[20] - Quote
Volume are up. Sorry for the delay.
You can have 30days of premium access for free with this code : alpha |
|
Nark Nalemir
Interstella Star System
0
|
Posted - 2016.12.04 19:28:28 -
[21] - Quote
Every time I do a search.... WoW!!! You broke the code! |
Saveritas
The Scope Gallente Federation
3
|
Posted - 2016.12.07 11:43:51 -
[22] - Quote
Enyah Al'ktar wrote:Volume are up. Sorry for the delay.
You can have 30days of premium access for free with this code : alpha
Eh...
"This code is not valid anymore. It may be out-dated or you may have already used it."
I'm quite sure I haven't used it already :-) |
Khal Aideron
The New Eden Yacht Club Galactic Skyfleet Empire
0
|
Posted - 2017.01.14 09:47:56 -
[23] - Quote
I paid 70m isk yesterday for the premium subscription and still my subscription hasn't been updated
Now I cannot access Eve-Spreadsheet as my trial has ran out
Please can you sort this as soon as possible
Thanks |
Enyah Al'ktar
Birds of Prey Inc
8
|
Posted - 2017.01.14 12:22:52 -
[24] - Quote
I have upgraded your account to premium and add 5 days as apologize for the delay |
Enyah Al'ktar
Birds of Prey Inc
8
|
Posted - 2017.03.12 10:26:12 -
[25] - Quote
Hello everyone !
The site will be in maintenance for few hours soon.
I'll initiate a migration to a new server. It can take time because I need to run some tests before allowing access to it.
Thanks for your patience
|
Enyah Al'ktar
Birds of Prey Inc
8
|
Posted - 2017.03.14 07:43:34 -
[26] - Quote
Site is up and running on his new server !
I didn't add a lot of news features, i worked on stability of the code to improve performance.
But even if there is not a lot of features, there is still some news to share.
Some change in subscription : - Basic plan is now free. - Premium plan remain the same but price is lowered to 50M/Month
Feature : - You can now filter on the search results. You can also filter using meta type (T1, T2, faction/officier/deadspace/etc)
Know issue: - The new filter zone can cause some weird thing when there is not a lot of result to display
Thanks to all users, and see you soon for new features (price in citadels )
ps : Feel free to send me a mail if you encounter any issues |
Somi Zulfi
Pandemic Horde Inc. Pandemic Horde
10
|
Posted - 2017.03.17 21:13:36 -
[27] - Quote
Cant add aPI keys, code broken, same with emails, or the alpha premium code... :/ |
Enyah Al'ktar
Birds of Prey Inc
10
|
Posted - 2017.03.19 17:07:47 -
[28] - Quote
Premium code shouldn't be available anymore. I will release an other one soon.
I have fixed the issue you have mentioned above |
Granio Nyveev
Jita Trade Association
0
|
Posted - 2017.03.20 15:44:12 -
[29] - Quote
This is probably a stupid question, so I apologize in advance.
I can't figure out the perspective relating to buy and sell prices. I'm used to looking at a buy price as a buy order (an order issued by someone else that you can fill by selling to them). So I see the "buy price" being the price I can sell at.
I think your spreadsheet works the other way around, (with a "buy price" actually being the price that I could buy the item at, or in other words it's the value of an existing sell order), but I was hoping you could confirm.
As an example, I looked up Panthers in Jita and Dodixie. Jita was set as the "sell order" and Dodixie was set as the "buy order". The following information was returned.
Buy Price: 864,000,000 Sell Price: 700,000,000 Profit: -220,600,000
I also don't understand how profit is calculated, as profit is generally the difference in prices, so regardless of my question above, I would expect the profit to be + or - 164,000,000. Granted, there are fees involved with trading, but 220,600,000 is around 34% higher than 164,000,000. I'm used to trading fees being around 5%, or 8% max (if issuing "buy orders" instead of filling "sell orders"). Where does 34% come from?
Oh, and lastly (and I probably should have mentioned this first), thanks for taking the time to put this together. It seems like a very useful tool and I think it's awesome you're sharing it with the community. Thanks!!!
|
Enyah Al'ktar
Birds of Prey Inc
10
|
Posted - 2017.03.20 17:00:00 -
[30] - Quote
There is no stupid question don't worry :) You are correct. Buy price is the price you will buy the item and sell price is the price you will sell the item. You change which type (buy order or sell order) is used during your search with filter.
For station trading you will mostly use buy order as buy price and sell order as sell price. But for region trading for example, you may want to switch that and use sell order as buy price and buy order as sell price.
It's just and indication for you to know the price you will pay to buy or sell an item on the market.
For the second part. Taxes are calculated with a simple formula : profit = (sell price - (broker + sale taxe)) - (buy price + broker)
Broker and sale taxe are calculated using your skills and standing so you should see same number ingame or in the tool
I'll run some test to see if the number you gave is correct or not. I will let you know once i have more information |
|
|
|
|
Pages: [1] 2 :: one page |
First page | Previous page | Next page | Last page |