Market Discussions

Hey Guys

So recently I had the great idea of making an inventory type spreadsheet for my trading to allow me to keep track of what I have in assets and what its current value is. Allowing me to check my trade alt without actually needing to log in.

One thing led to another and I realized I need more data points.

Some basic info on what i'm working with so far.

- Roughly 350 Items (Will probably extend to around 500)
- In my first spreadsheet I used just data from EVE-Central (http://api.eve-central.com/api/marketstat?typeid=34&usesystem=30000142)
- I did all the calculations I wanted from the 'live' data

Now I realize that I need some historical data to really do what I want with my spreadsheet but I am coming up against several issues while trying to create the new one.

My main issue is where to get the data from. I am having issues getting historical data from EVE Central and took it from EVE Markets instead. As a result I am now using both which is not ideal when collecting up to 500 items. While googling and researching my issues I am seeing a lot of things about CREST. considering I have no coding knowledge, Would it be better for me to use this? I have no idea where to start with this and the Evelopedia pages are now obviously down.

What is the url to get price history from EVE Central? I have been using the below, as instructed on their site and not getting any data. Am I doing it wrong or does it not work?
http://api.eve-central.com/api/history/for/type/34/system/Jita/bid/1

I have also had issues with the Mexallon history from EVE Markets. It seems not to show yesterdays values. I think this happened yesterday when I originally put it in, and has continued today. Is anyone else aware of this issue? or how to get around it?
http://marketdata.com/api/item_history2.txt?char_name=Edrick_Eideard&region_ids=10000002&type_ids=36&days=6

Sorry for my incoherent questions. My basic questions is - In what way and where should I import my data from? Considering I want the following data points. (And in as few Data grabs as possible, as 500 items can take a while to refresh, especially if each one grabs data from 2 places)

- Live Value
- Last 5 days history (Prices, Volumes (Both buy and sell would be nice))

That Eve Marketdata API hasn't been updated since 29 Feb.