Grand Exchange Database
From the RuneScape Wiki, the wiki for all things RuneScape
- Not to be confused with the Grand Exchange itself, nor this wiki's Grand Exchange Market Watch.
The Grand Exchange Database, very similar to this wiki's own Grand Exchange Market Watch, is a feature on the RuneScape website, allowing players, both free and member, to view price changes of a specific item over the previous 30 days.
Currently, after being released on 15 April 2008, it is in beta stage, and Jagex would like feedback from users.[1].
Contents |
[edit] Using the database
Users of the Database can search items by choosing the alphabets on the left or just type the name of the item under the marquee in the "search" box, then select the price range and whether the item is member-only or non-member or both.
Note that the search result may be a little bit sidetracked. For example, "Guthix page" would result in items named with "Guthix" or "page" or are "Guthix"-related. However, wrapping "Guthix page" in quotation marks (") in the search box in the database would result in a more precise search. [2] The yellow and grey stars before the picture of the item in the search results indicate that the items are member-only and non-member respectively.
Prices above 10,000 coins are rounded to 0.1k, while prices above 1 million are rounded to 1.0m.
[edit] Tracking personalized items
Using Microsoft Excel, it is possible to track several of your personalized items at once.
- Search for an item, and narrow down the number of items in the search to the items you want to track. This is done be adding minus signs (-) before a term you want to negate.
- Example: For excluding any items with wine in it, type -wine
- Copy the address from the address bar, and go to Microsoft Excel. Click 'Data' on the main toolbar, scroll down to 'Get External Data', and click 'New Web Query'.
- Insert the address in the correct text box.
- For Excel 2000 and earlier: Put the address in the correct box. Click the check box for 'Only the Tables' and 'Full HTML Formatting'. Click OK.
- For Excel 2003 and later: Put the address in the address bar, and you will see the page soon. Click the arrow in a box next to the table that contains the item(s). Click options and click the box that says 'Full HTML Formatting'. Click Import.
- For Excel 2007: Under the "Data" tab, click on "From Web". Enter the item's address into the Address bar and hit Enter. Click the arrow at the top left of the page, and click "Import", located at the bottom left of the window. Choose which cell to enter the data into, and click "Ok". The data should appear in a few seconds.
- If you only want to import the data without the pictures or color (i.e. just the text), make sure "None" is selected under Options -> Formatting before the data is imported.
- To Update, click 'Data', and click Refresh Data.
[edit] Fansites
While the Grand Exchange Database was a welcome addition, some fansites saw this as another one of Jagex's attempts to "kill off" fansites due to the fact that a large majority of fansites had a "price guide" database to check prices on items (An example being the RuneScape Wiki's Grand Exchange Market Watch). Other examples of such behaviour by Jagex can be seen in the Game Guide as a whole, and the QuestHelp system.
[edit] Trivia
- There are many features in the Grand Exchange Database that resemble the Stock Market. Examples are the price graph, and the scrolling prices in the Grand Exchange banner at the top of the page.
- There are approximately 3,200 items in the Grand Exchange Database.
[edit] References
- ^ Update: Grand Exchange Database, paragraph four.
- ^ RuneScape Grand Exchange Database search tips page
