Shop

Products

Live FOREX (Pay Monthly)

Price from $92.00

Available to Diamond members only as a part of the Live Prices product.


More Details Add to cart Buy now

Live FOREX (Annual)

Price from $1,104.00

Available to Diamond members only as a part of the Live Prices product.


More Details Add to cart Buy now

Dow Jones Complete News Package (months)

Price from $159.00

More Details Add to cart Buy now

Delayed FOREX (Annual)

Price from $90.00

Available to Diamond members only as a part of the Live Prices product.


More Details Add to cart Buy now

Delayed FOREX (Pay Monthly)

Price from $7.50

Available to Diamond members only as a part of the Live Prices product.


More Details Add to cart Buy now

Delayed European (inc. LIFFE) & Asia/Pacific Futures (months)

Price from $9.50

Available to Diamond members only as a part of the Live Prices product.


More Details Add to cart Buy now

Delayed European (inc. LIFFE) & Asia/Pacific Futures (Annual)

Price from $114.00

Available to Diamond members only as a part of the Live Prices product.


More Details Add to cart Buy now

Delayed US (inc. ICE & CBOT) and Canadian Futures (Annual)

Price from $204.00

Available to Diamond members only as a part of the Live Prices product.


More Details Add to cart Buy now

Delayed US (inc. ICE & CBOT) and Canadian Futures (months)

Price from $17.00

Available to Diamond members only as a part of the Live Prices product.


More Details Add to cart Buy now

ICE Futures US (annual)

Price from $1,212.00

This will give you access to Live Sugar Prices for New York No 11 and US No 14 as well as all other prices quoted by NYBOT. Available to Diamond members only as a part of the Live Prices product.


More Details Add to cart Buy now

ICE LIFFE Exchange Fees (annual)

Price from $1,212.00

This will give you access to Live Sugar Prices for London No 5 as well as all other prices quoted by LIFFE. Available to Diamond members only as a part of the Live Prices product.


More Details Add to cart Buy now

ICE Futures US (pay monthly)

Price from $101.00

This will give you access to Live Sugar Prices for New York No 11 and US No 14 as well as all other prices quoted by NYBOT. Available to Diamond members only as a part of the Live Prices product.


More Details Add to cart Buy now

ICE LIFFE Exchange Fees (pay monthly)

Price from $101.00

This will give you access to Live Sugar Prices for London No 5 as well as all other prices quoted by LIFFE. Available to Diamond members only as a part of the Live Prices product.


More Details Add to cart Buy now

(default) 56 queries took 152 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `shop_categories`12124
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';114
3SHOW FULL COLUMNS FROM `shop_access_levels`554
4SHOW FULL COLUMNS FROM `website_access_levels`335
5SHOW FULL COLUMNS FROM `website_contents`35354
6SHOW FULL COLUMNS FROM `website_content_types`663
7SHOW FULL COLUMNS FROM `website_top_categories`10104
8SHOW FULL COLUMNS FROM `website_top_category_types`224
9SHOW FULL COLUMNS FROM `website_categories`334
10SHOW FULL COLUMNS FROM `website_categories_website_contents`223
11SHOW FULL COLUMNS FROM `website_categories_website_top_categories`226
12SHOW FULL COLUMNS FROM `countries`17174
13SHOW FULL COLUMNS FROM `people`94946
14SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';110
15SHOW FULL COLUMNS FROM `user_types`11115
16SHOW FULL COLUMNS FROM `person_shop_products`885
17SHOW FULL COLUMNS FROM `shop_orders`23235
18SHOW FULL COLUMNS FROM `payment_methods`224
19SHOW FULL COLUMNS FROM `shop_order_statuses`224
20SHOW FULL COLUMNS FROM `discounts`664
21SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_bin';113
22SHOW FULL COLUMNS FROM `logins`444
23SHOW FULL COLUMNS FROM `interests`334
24SHOW FULL COLUMNS FROM `interest_groups`225
25SHOW FULL COLUMNS FROM `interests_people`335
26SHOW FULL COLUMNS FROM `people_shop_categories`224
27SHOW FULL COLUMNS FROM `shop_ordered_products`775
28SHOW FULL COLUMNS FROM `shop_products`27275
29SHOW FULL COLUMNS FROM `shop_pricing_units`334
30SHOW FULL COLUMNS FROM `shop_access_levels_shop_products`333
31SHOW FULL COLUMNS FROM `shop_addon_products`226
32SHOW FULL COLUMNS FROM `shop_sub_products`446
33SHOW FULL COLUMNS FROM `your_menu_items`554
34SHOW FULL COLUMNS FROM `configuration`554
35SELECT `Country`.`id`, `Country`.`name`, `Country`.`iso_code`, `Country`.`gmt_offset`, `Country`.`int_dial_code`, `Country`.`is_domicile_country`, `Country`.`is_origin_country`, `Country`.`is_destination_country`, `Country`.`is_trading_country`, `Country`.`name_fr`, `Country`.`name_es`, `Country`.`name_pt`, `Country`.`name_de`, `Country`.`name_cn`, `Country`.`name_th`, `Country`.`name_ru`, `Country`.`tax_rate` FROM `countries` AS `Country` WHERE `Country`.`id` = 270 LIMIT 1110
36SELECT `ShopAccessLevel`.`id`, `ShopAccessLevel`.`name`, `ShopAccessLevel`.`description`, `ShopAccessLevel`.`price`, `ShopAccessLevel`.`visible` FROM `shop_access_levels` AS `ShopAccessLevel` WHERE `ShopAccessLevel`.`id` = 1 LIMIT 1110
37SELECT `WebsiteAccessLevel`.`id`, `WebsiteAccessLevel`.`name`, `WebsiteAccessLevel`.`shop_access_level_id` FROM `website_access_levels` AS `WebsiteAccessLevel` WHERE `WebsiteAccessLevel`.`id` = 1 LIMIT 1110
38SELECT `Configuration`.`id`, `Configuration`.`name`, `Configuration`.`value`, `Configuration`.`input_type`, `Configuration`.`cronjob` FROM `configuration` AS `Configuration` WHERE 1 = 1 16160
39SELECT `WebsiteContent`.`id`, `WebsiteContent`.`name` FROM `website_contents` AS `WebsiteContent` WHERE `WebsiteContent`.`in_footer` = 1 AND `WebsiteContent`.`visible` = 1 440
40SELECT `WebsiteContent`.`id`, `WebsiteContent`.`name` FROM `website_contents` AS `WebsiteContent` WHERE `WebsiteContent`.`subscription_type` = 1 AND `WebsiteContent`.`visible` = 1 ORDER BY IF(name = 'Compare Levels', 1, 0) ASC, id ASC 440
41SELECT `WebsiteContent`.`id`, `WebsiteContent`.`name` FROM `website_contents` AS `WebsiteContent` WHERE `WebsiteContent`.`information` = 1 AND `WebsiteContent`.`visible` = 1 440
42SELECT `WebsiteContent`.`id`, `WebsiteContent`.`name` FROM `website_contents` AS `WebsiteContent` WHERE `WebsiteContent`.`service` = 1 AND `WebsiteContent`.`visible` = 1 330
43SHOW FULL COLUMNS FROM `settlement_prices`32324
44SELECT `SettlementPrice`.`id`, `SettlementPrice`.`date`, `SettlementPrice`.`month_1`, `SettlementPrice`.`month_2`, `SettlementPrice`.`month_3`, `SettlementPrice`.`month_4`, `SettlementPrice`.`month_5`, `SettlementPrice`.`market`, `SettlementPrice`.`entered_by`, `SettlementPrice`.`month`, `SettlementPrice`.`year`, `SettlementPrice`.`month_1_name`, `SettlementPrice`.`month_2_name`, `SettlementPrice`.`month_3_name`, `SettlementPrice`.`month_4_name`, `SettlementPrice`.`month_5_name`, `SettlementPrice`.`open_1`, `SettlementPrice`.`open_2`, `SettlementPrice`.`open_3`, `SettlementPrice`.`open_4`, `SettlementPrice`.`open_5`, `SettlementPrice`.`change_1`, `SettlementPrice`.`change_2`, `SettlementPrice`.`change_3`, `SettlementPrice`.`change_4`, `SettlementPrice`.`change_5`, `SettlementPrice`.`volume_1`, `SettlementPrice`.`volume_2`, `SettlementPrice`.`volume_3`, `SettlementPrice`.`volume_4`, `SettlementPrice`.`volume_5`, `SettlementPrice`.`visible` FROM `settlement_prices` AS `SettlementPrice` WHERE `SettlementPrice`.`market` = '5' ORDER BY `SettlementPrice`.`date` DESC LIMIT 1110
45SELECT `SettlementPrice`.`id`, `SettlementPrice`.`date`, `SettlementPrice`.`month_1`, `SettlementPrice`.`month_2`, `SettlementPrice`.`month_3`, `SettlementPrice`.`month_4`, `SettlementPrice`.`month_5`, `SettlementPrice`.`market`, `SettlementPrice`.`entered_by`, `SettlementPrice`.`month`, `SettlementPrice`.`year`, `SettlementPrice`.`month_1_name`, `SettlementPrice`.`month_2_name`, `SettlementPrice`.`month_3_name`, `SettlementPrice`.`month_4_name`, `SettlementPrice`.`month_5_name`, `SettlementPrice`.`open_1`, `SettlementPrice`.`open_2`, `SettlementPrice`.`open_3`, `SettlementPrice`.`open_4`, `SettlementPrice`.`open_5`, `SettlementPrice`.`change_1`, `SettlementPrice`.`change_2`, `SettlementPrice`.`change_3`, `SettlementPrice`.`change_4`, `SettlementPrice`.`change_5`, `SettlementPrice`.`volume_1`, `SettlementPrice`.`volume_2`, `SettlementPrice`.`volume_3`, `SettlementPrice`.`volume_4`, `SettlementPrice`.`volume_5`, `SettlementPrice`.`visible` FROM `settlement_prices` AS `SettlementPrice` WHERE `SettlementPrice`.`market` = '11' ORDER BY `SettlementPrice`.`date` DESC LIMIT 1110
46SELECT `SettlementPrice`.`id`, `SettlementPrice`.`date`, `SettlementPrice`.`month_1`, `SettlementPrice`.`month_2`, `SettlementPrice`.`month_3`, `SettlementPrice`.`month_4`, `SettlementPrice`.`month_5`, `SettlementPrice`.`market`, `SettlementPrice`.`entered_by`, `SettlementPrice`.`month`, `SettlementPrice`.`year`, `SettlementPrice`.`month_1_name`, `SettlementPrice`.`month_2_name`, `SettlementPrice`.`month_3_name`, `SettlementPrice`.`month_4_name`, `SettlementPrice`.`month_5_name`, `SettlementPrice`.`open_1`, `SettlementPrice`.`open_2`, `SettlementPrice`.`open_3`, `SettlementPrice`.`open_4`, `SettlementPrice`.`open_5`, `SettlementPrice`.`change_1`, `SettlementPrice`.`change_2`, `SettlementPrice`.`change_3`, `SettlementPrice`.`change_4`, `SettlementPrice`.`change_5`, `SettlementPrice`.`volume_1`, `SettlementPrice`.`volume_2`, `SettlementPrice`.`volume_3`, `SettlementPrice`.`volume_4`, `SettlementPrice`.`volume_5`, `SettlementPrice`.`visible` FROM `settlement_prices` AS `SettlementPrice` WHERE `SettlementPrice`.`market` = '16' ORDER BY `SettlementPrice`.`date` DESC LIMIT 1110
47SELECT `SettlementPrice`.`id`, `SettlementPrice`.`date`, `SettlementPrice`.`month_1`, `SettlementPrice`.`month_2`, `SettlementPrice`.`month_3`, `SettlementPrice`.`month_4`, `SettlementPrice`.`month_5`, `SettlementPrice`.`market`, `SettlementPrice`.`entered_by`, `SettlementPrice`.`month`, `SettlementPrice`.`year`, `SettlementPrice`.`month_1_name`, `SettlementPrice`.`month_2_name`, `SettlementPrice`.`month_3_name`, `SettlementPrice`.`month_4_name`, `SettlementPrice`.`month_5_name`, `SettlementPrice`.`open_1`, `SettlementPrice`.`open_2`, `SettlementPrice`.`open_3`, `SettlementPrice`.`open_4`, `SettlementPrice`.`open_5`, `SettlementPrice`.`change_1`, `SettlementPrice`.`change_2`, `SettlementPrice`.`change_3`, `SettlementPrice`.`change_4`, `SettlementPrice`.`change_5`, `SettlementPrice`.`volume_1`, `SettlementPrice`.`volume_2`, `SettlementPrice`.`volume_3`, `SettlementPrice`.`volume_4`, `SettlementPrice`.`volume_5`, `SettlementPrice`.`visible` FROM `settlement_prices` AS `SettlementPrice` WHERE `SettlementPrice`.`market` = '5' ORDER BY `SettlementPrice`.`date` DESC LIMIT 1110
48SELECT `SettlementPrice`.`id`, `SettlementPrice`.`date`, `SettlementPrice`.`month_1`, `SettlementPrice`.`month_2`, `SettlementPrice`.`month_3`, `SettlementPrice`.`month_4`, `SettlementPrice`.`month_5`, `SettlementPrice`.`market`, `SettlementPrice`.`entered_by`, `SettlementPrice`.`month`, `SettlementPrice`.`year`, `SettlementPrice`.`month_1_name`, `SettlementPrice`.`month_2_name`, `SettlementPrice`.`month_3_name`, `SettlementPrice`.`month_4_name`, `SettlementPrice`.`month_5_name`, `SettlementPrice`.`open_1`, `SettlementPrice`.`open_2`, `SettlementPrice`.`open_3`, `SettlementPrice`.`open_4`, `SettlementPrice`.`open_5`, `SettlementPrice`.`change_1`, `SettlementPrice`.`change_2`, `SettlementPrice`.`change_3`, `SettlementPrice`.`change_4`, `SettlementPrice`.`change_5`, `SettlementPrice`.`volume_1`, `SettlementPrice`.`volume_2`, `SettlementPrice`.`volume_3`, `SettlementPrice`.`volume_4`, `SettlementPrice`.`volume_5`, `SettlementPrice`.`visible` FROM `settlement_prices` AS `SettlementPrice` WHERE `SettlementPrice`.`market` = '11' ORDER BY `SettlementPrice`.`date` DESC LIMIT 1110
49SHOW FULL COLUMNS FROM `prices`24244
50SELECT `Price`.`id`, `Price`.`retrieved`, `Price`.`delay`, `Price`.`root`, `Price`.`symbol`, `Price`.`description`, `Price`.`month`, `Price`.`year`, `Price`.`recent`, `Price`.`change_open`, `Price`.`change_old_settle`, `Price`.`opening_price`, `Price`.`high`, `Price`.`low`, `Price`.`volume`, `Price`.`opening_interest`, `Price`.`exchange`, `Price`.`time`, `Price`.`entered_date`, `Price`.`person_id`, `Price`.`change`, `Price`.`total_volume`, `Price`.`new_settlement`, `Price`.`oldsettle` FROM `prices` AS `Price` WHERE `Price`.`root` = 'W-ICL' ORDER BY `Price`.`id` ASC LIMIT 20880
51SELECT `Price`.`id`, `Price`.`retrieved`, `Price`.`delay`, `Price`.`root`, `Price`.`symbol`, `Price`.`description`, `Price`.`month`, `Price`.`year`, `Price`.`recent`, `Price`.`change_open`, `Price`.`change_old_settle`, `Price`.`opening_price`, `Price`.`high`, `Price`.`low`, `Price`.`volume`, `Price`.`opening_interest`, `Price`.`exchange`, `Price`.`time`, `Price`.`entered_date`, `Price`.`person_id`, `Price`.`change`, `Price`.`total_volume`, `Price`.`new_settlement`, `Price`.`oldsettle` FROM `prices` AS `Price` WHERE `Price`.`root` = 'SB' ORDER BY `Price`.`id` ASC LIMIT 2012120
52SELECT `Price`.`id`, `Price`.`retrieved`, `Price`.`delay`, `Price`.`root`, `Price`.`symbol`, `Price`.`description`, `Price`.`month`, `Price`.`year`, `Price`.`recent`, `Price`.`change_open`, `Price`.`change_old_settle`, `Price`.`opening_price`, `Price`.`high`, `Price`.`low`, `Price`.`volume`, `Price`.`opening_interest`, `Price`.`exchange`, `Price`.`time`, `Price`.`entered_date`, `Price`.`person_id`, `Price`.`change`, `Price`.`total_volume`, `Price`.`new_settlement`, `Price`.`oldsettle` FROM `prices` AS `Price` WHERE `Price`.`root` = 'SFQ' ORDER BY `Price`.`id` ASC LIMIT 2011110
53SELECT `ShopCategory`.`id`, `ShopCategory`.`name`, `ShopCategory`.`description`, `ShopCategory`.`allow_multiple_items_in_basket`, `ShopCategory`.`visible`, `ShopCategory`.`parent_id`, `ShopCategory`.`available_as_email_alert`, `ShopCategory`.`full_months_only`, `ShopCategory`.`shop_access_level_id`, `ShopCategory`.`image_file`, `ShopCategory`.`lft`, `ShopCategory`.`rght` FROM `shop_categories` AS `ShopCategory` WHERE `ShopCategory`.`id` = 309 LIMIT 1110
54SELECT `ChildShopCategory`.`id`, `ChildShopCategory`.`name`, `ChildShopCategory`.`description`, `ChildShopCategory`.`allow_multiple_items_in_basket`, `ChildShopCategory`.`visible`, `ChildShopCategory`.`parent_id`, `ChildShopCategory`.`available_as_email_alert`, `ChildShopCategory`.`full_months_only`, `ChildShopCategory`.`shop_access_level_id`, `ChildShopCategory`.`image_file`, `ChildShopCategory`.`lft`, `ChildShopCategory`.`rght` FROM `shop_categories` AS `ChildShopCategory` WHERE `ChildShopCategory`.`parent_id` = (309) ORDER BY `ChildShopCategory`.`name` ASC 000
55SELECT `ShopProduct`.`id`, `ShopProduct`.`name`, `ShopProduct`.`featured`, `ShopProduct`.`feature_date`, `ShopProduct`.`feature_text`, `ShopProduct`.`image_filename`, `ShopProduct`.`short_description`, `ShopProduct`.`full_description`, `ShopProduct`.`tax_payable`, `ShopProduct`.`small_image_url`, `ShopProduct`.`big_image_url`, `ShopProduct`.`file_url`, `ShopProduct`.`active`, `ShopProduct`.`shop_category_id`, `ShopProduct`.`new_shop_access_level_id`, `ShopProduct`.`can_buy_separately`, `ShopProduct`.`default_quantity`, `ShopProduct`.`minimum_quantity`, `ShopProduct`.`can_change_quantity`, `ShopProduct`.`shop_pricing_unit_id`, `ShopProduct`.`can_pay_by_instalments`, `ShopProduct`.`sample_file_url`, `ShopProduct`.`available_as_email_alert`, `ShopProduct`.`created`, `ShopProduct`.`deleted`, `ShopProduct`.`quantity_must_not_exceed_subscription_length`, `ShopProduct`.`subscription` FROM `shop_products` AS `ShopProduct` WHERE ((`ShopProduct`.`can_buy_separately` = 1) AND (`ShopProduct`.`active` = 1) AND (`ShopProduct`.`deleted` = 0)) AND `ShopProduct`.`shop_category_id` = (309) ORDER BY `ShopProduct`.`created` DESC 13130
56SELECT `ShopAccessLevel`.`id`, `ShopAccessLevel`.`name`, `ShopAccessLevel`.`description`, `ShopAccessLevel`.`price`, `ShopAccessLevel`.`visible`, `ShopAccessLevelsShopProduct`.`shop_product_id`, `ShopAccessLevelsShopProduct`.`shop_access_level_id`, `ShopAccessLevelsShopProduct`.`price` FROM `shop_access_levels` AS `ShopAccessLevel` JOIN `shop_access_levels_shop_products` AS `ShopAccessLevelsShopProduct` ON (`ShopAccessLevelsShopProduct`.`shop_product_id` IN (52713, 52712, 52505, 52449, 52448, 48633, 48630, 48629, 48627, 40080, 40079, 40076, 40075) AND `ShopAccessLevelsShopProduct`.`shop_access_level_id` = `ShopAccessLevel`.`id`) ORDER BY `ShopAccessLevelsShopProduct`.`price` ASC 65650