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

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

EVE General Discussion

 
  • Topic is locked indefinitely.
 

downloading prcies to my excell spreadsheet
Author
Previous Topic Next Topic
lab geek011
I am not a Crook
#1 - 2013-01-09 21:39:06 UTC
Hi all,

Im quite new to this but i have been doing some spread sheets for minerals that i mine and then the few items i make, at the moment i have to manually enter the prices in to my spreadsheet from the market on jita but this is taking time. I know there are programs out there and on forum that say it will do it for youbut im concerned if i download they could contain viruses or hacking software that woudl then be on my pc

is there a way that i can do it myself so that when i load up my excell sheet it will automatically get the prices from Jita or a location of my choice.

I have seen some excell spread sheets that do it but again i have to download. Is there a safe site that is trusted with CCP so i know they are safe, dont mind even paying if it does what i need

any help would be great

Thanks
Katran Luftschreck
Royal Ammatar Engineering Corps
#2 - 2013-01-09 21:44:39 UTC
Not aware of any application that does this. Which only means that someone needs to make one.

http://youtu.be/t0q2F8NsYQ0
Brutus King
Brutor Tribe
Minmatar Republic
#3 - 2013-01-09 21:45:50 UTC
OP, I hate you.
Feer Truelight
#4 - 2013-01-09 21:46:22 UTC
Use spreadsheets in Google Docs and import data from EVE-central via the built-in XML import feature.

8/7/2006 3:39:36 PM UTC FreeCCP Promotional Game Time 7 Days Paid

6/1/2012 5:48:57 PM UTC PayPal 1 x 1 Month EVE Subscription + Signup €19.95 Paid

CCP took 6 years to convert me to a (still) paying subscriber :)
AyayaPanda
Ministry of War
Amarr Empire
#5 - 2013-01-09 21:46:51 UTC
You can pull real time market price from evecentral

http://community.eveonline.com/ingameboard.asp?a=topic&threadID=1558412

convo me if you have further questions o/
Rath Kelbore
Caldari Provisions
Caldari State
#6 - 2013-01-09 22:37:40 UTC
lab geek011 wrote:
Hi all,

Im quite new to this but i have been doing some spread sheets for minerals that i mine and then the few items i make, at the moment i have to manually enter the prices in to my spreadsheet from the market on jita but this is taking time. I know there are programs out there and on forum that say it will do it for youbut im concerned if i download they could contain viruses or hacking software that woudl then be on my pc

is there a way that i can do it myself so that when i load up my excell sheet it will automatically get the prices from Jita or a location of my choice.

I have seen some excell spread sheets that do it but again i have to download. Is there a safe site that is trusted with CCP so i know they are safe, dont mind even paying if it does what i need

any help would be great

Thanks


https://forums.eveonline.com/default.aspx?g=posts&t=8074

This is the best industrial tool I've found. You probably won't want to download it because it's not officially sanctioned by CCP. You are missing out.

I plan on living forever.......so far, so good.
Alex Grison
Grison Universal
#7 - 2013-01-09 23:05:06 UTC
Excel can pull data from a web source ( read some kind of market API )

Personally I would use C# to write a plugin for Excel to automatically pull pricing data from the evecentral API and then sort it out a bit.

This would be notably easier than using....basic.

yes
Solstice Project
Sebiestor Tribe
Minmatar Republic
#8 - 2013-01-10 02:21:26 UTC  |  Edited by: Solstice Project
There is. There's one guy using javascript, the ingame webbrowser and the API
to download whole regions at a time, containing all the market data.
All the items, all the prices, of a whole region. To his harddrive.

I petitioned him. I'd not suggest trying to find out how it works. :)
Zifrian
University of Caille
Gallente Federation
#9 - 2013-01-10 02:28:55 UTC
Check the science and industry forum or the eve technology lab for a question like this.

You can do the inline update thing mentioned above I believe. I've never messed with it because I built the program in my sig to get away from updating spreadsheets all the time. Dedaf's is fine (linked above) if you want to use a spreadsheet.

Maximze your Industry Potential! - Download EVE Isk per Hour!

Import CCP's SDE - EVE SDE Database Builder
Xercodo
Cruor Angelicus
#10 - 2013-01-10 02:57:50 UTC
Add all the items and minerals into the in-game market quickbar.

Then when gathering prices select the buy or sell order you want to use for that data and Ctrl+V it. You can now paste this data directly into a spread sheet :D

With some fancy formulas you can get Excel to remove the " ISK" at the end of each of them and use the numbers raw.

The Drake is a Lie