How to import EvE market data in a trading platform - Page 6 of 6

Appendix: how to create CSV data dumps

Vaerah Vahrokha provides CSV data dumps on request, but you may also create your own.

Here’s how.

1) Look at the provided Mexallon example for the proper format to use.

The CSV file should look as follows:

2010-06-01,24.94,24.98,24.80,24.94,2028338264
2010-06-02,24.94,24.94,24.62,24.81,2269631111
2010-06-03,24.81,24.86,24.72,24.80,1798113922
… many other rows …

Each row contains:

– a date expressed in YYYY-MM-DD format, left padded with zeroes for numbers below 10.

– open (price at daily session start)

– high (highest price during the day)

– low (lowest price during the day)

– close (price at daily session end)

– volume traded in units.

You may easily extract high, low and volume off the EvE cache or market exports. Since EvE markets are open almost 24/7, the close of one day may be copied onto the open of the next day. There’s basically only one tricky value to calculate or input and it’s the close. That may be manually inputed (or extrapolated with a software / whatever) by looking at the minimum buy order at the time the trading day ends. Best times to check that value are at midnight GMT and right before server down time.

Another, easy way to feed quality CSV data dumps to MultiCharts^® is to directly import them from the ~1~.

Pages: 1 2 3 4 5 6

Definitioner

1 (OHLC)

Open, High, Low, Close (and sometimes Volume) data, is a finance industry standards format used to represent price evolution during a certain period of time (daily, weekly, hourly...). OHLC data are consumed by financial analysis applications and by charting software to represent price action.

1 (audit)

The general definition of an audit is an evaluation of a person, organization, system, process, enterprise, project or product.

1 (Meta game)

Meta gaming is a broad term usually used to define any strategy, action or method used in a game which transcends a prescribed ruleset, uses external factors to affect the game, or goes beyond the supposed limits or environment set by the game. Another definition refers to the game universe outside of the game itself.

1 (emergent)

Emergent gameplay refers to complex situations in video games, board games, or table top role-playing games that emerge from the interaction of relatively simple game mechanics.

1 (sandbox)

A sandbox game is a type of video game design where a player can roam freely through a virtual world and is given considerable freedom in choosing how or when to approach objectives. Sandbox emphasises a paradigm where, as in a physical sandbox, the user is entertained by his ability to do as they wish creatively and with there being "no right way" of playing the game

1 (discretionary)

A discretionary method is a trading method where little or no mechanical tools and procedures are used to decide the trades. A discretionary trader applies a solid ruleset basing on a flexible interpretation of the market

1 (PLEX)

A Pilot License Extension (PLEX) is an item that adds 30 days of game time to an EvE Online account. It is freely traded like any other in game item. CCP accepts to convert in game PLEXES to real money in case disasters and emergencies happen.

1 (NEISIN)

A New Eden Interstellar Securities Identification Number (NEISIN) uniquely identifies a security. While its structure is identical and strictly compliant with "real life" ISINs, NEISINs are tailored to New Eden investments and contracts.

Appendix: how to create CSV data dumps

Advertisment

Comments