EVE Trading Extravaganza
Generates pricing, volumes, and potential profit margins for EVE Online trading items. The 'Calc Sheet' allows users to input item names and view buy/sell prices, gross margins, and net margins. It includes essential columns such as 'TypeID', 'Average Daily Region Vol (EMD)', and 'Net Percentage Margin'. The 'CharOrders' tab facilitates tracking orders using API credentials, while the 'Query Example' provides a guide for utilizing the QUERY function effectively. This comprehensive tool is designed for traders looking to optimize their EVE Online trading strategies.
Content article
Dozens of items are listed in the EVE Trading Extravaganza spreadsheet, detailing their pricing, volumes, and profit margins. The "Calc Sheet" features a variety of items such as the Onyx, which has a TypeID of 11995, and the 100MN Afterburner II with a TypeID of 12068. Both currently show #N/A for buy and sell prices, indicating that data may not be available or needs to be updated. The 10MN Afterburner II, with a TypeID of 12058, also reflects this lack of data.
In contrast, the 1200mm Artillery Cannon II, identified by TypeID 2865, similarly lacks pricing information, as do several other items like the 125mm Railgun II (TypeID 10680) and the 150mm Railgun II (TypeID 3074). The 1MN Afterburner II (TypeID 438) and the 200mm Railgun II (TypeID 12346) follow suit, all showing #N/A for their respective buy and sell prices.
The spreadsheet also highlights the importance of regional volume information, which is crucial for traders. For example, the average daily regional volume for the items is noted as 0 across the board, indicating that either the items are not being traded or the data is not currently accessible. The "Tips" section advises users to familiarize themselves with functions like VLOOKUP and QUERY to effectively navigate the extensive data available in the spreadsheet.
The "CharOrders" tab allows users to input their API KeyID and Vcode to retrieve order information. However, the current data shows #N/A across all fields, suggesting that no orders have been retrieved or entered. This tab is crucial for users looking to manage their trading orders, as it provides fields for StationID, ItemID, Item Name, Station Name, Volume Entered, Volume Remaining, Price, Time, Order Status, and Range.
In the "Query Example" tab, users can see a practical application of the QUERY function. The example query selects specific columns from the "Calc Sheet," filtering for items with a net margin greater than 10%. This demonstrates how to extract meaningful insights from the data, although the actual results are not displayed in the content provided.
Lockefox's contributions are highlighted across various tabs, including "Lockefox Functions," which offers links to scripts and resources for further trading insights. The "CrestPrice" and "SystemIndexes" tabs also reference Lockefox's work, though they currently show #ERROR!, indicating that the functions may not be executing correctly or that the data is not being pulled as intended.
The "TypeID" tab lists various items and their corresponding details, such as the Tritanium (TypeID 34) and Pyerite (TypeID 35), both of which are essential materials in the game. The entries provide information about their locations, including the stations where they can be found, such as Klingt IX - Moon 3 and Geffur VIII - Moon 10, respectively.