A free and (almost) real time feed of all FTSE100 companies, including price and change since previous close of trading price.
This site was made by Richard Allen as a play-around with Twitter Bootstrap. The FTSE data is pulled from Google finance using the =googlefinance
function within Google Docs. Although it aims to be real time, and most quotes are accurate to less than a few second; note that some may be delayed up to 20 minutes. For this reason this isn't to be used for trading or advice and is provided "as is" solely for informational purposes. You're more than welcome to use this for non-commercial use, but it's licensed under a Creative Commons Attribution-NonCommercial 3.0 Unported License.. If you have any questions feel free to get in contact with me!....Enjoy!!!<>/p>
A complete feed of the dataset can be requested via the following request;
https://spreadsheets.google.com/feeds/list/0AhySzEddwIC1dEtpWF9hQUhCWURZNEViUmpUeVgwdGc/1/public/basic
Try it
https://spreadsheets.google.com/feeds/list/0AhySzEddwIC1dEtpWF9hQUhCWURZNEViUmpUeVgwdGc/1/public/basic?alt=json-in-script
Try it
https://spreadsheets.google.com/feeds/list/0AhySzEddwIC1dEtpWF9hQUhCWURZNEViUmpUeVgwdGc/1/public/basic?alt=json
Try it
https://spreadsheets.google.com/feeds/list/0AhySzEddwIC1dEtpWF9hQUhCWURZNEViUmpUeVgwdGc/1/public/basic?alt=rss
Try it
A query can be made for a single company using the following request;
https://spreadsheets.google.com/feeds/list/0AhySzEddwIC1dEtpWF9hQUhCWURZNEViUmpUeVgwdGc/1/public/basic?sq=symbol=
The available companies can be found in the next section.
Symbol | Company Name | Symbol | Company Name |
AAL.L | ANGLO AMERICAN | JMAT.L | JOHNSON MATTHEY PLC |
ABF.L | ASSOCIAT BRIT FOODS | KAZ.L | KAZAKHMYS |
ADM.L | ADMIRAL GROUP | KGF.L | KINGFISHER |
ADN.L | ABERDEEN ASSET MGMT | LAND.L | LAND SEC R.E.I.T. |
AGK.L | AGGREKO | LGEN.L | LEGAL & GENERAL |
AMEC.L | AMEC | LLOY.L | LLOYDS BANKING GRP |
ANTO.L | ANTOFAGASTA | MGGT.L | MEGGITT |
ARM.L | ARM HOLDINGS | MKS.L | MARKS & SPENCER |
ASHM.L | ASHMORE GRP | MRW.L | MORRISON SUPERMKTS |
AV.L | AVIVA | NG.L | NATIONAL GRID |
AZN.L | ASTRAZENECA | NXT.L | NEXT |
BA.L | BAE SYSTEMS | OML.L | OLD MUTUAL |
BARC.L | BARCLAYS | PFC.L | PETROFAC |
BATS.L | BRIT AMER TOBACCO | POLY.L | POLYMETAL INTL |
BG.L | BG GROUP | PRU.L | PRUDENTIAL |
BLND.L | BRIT LAND CO REIT | PSON.L | PEARSON |
BLT.L | BHP BILLITON | RB.L | RECKITT BENCK GRP |
BNZL.L | BUNZL | RBS.L | ROYAL BK SCOTL GR |
BP.L | BP | RDSB.L | ROYAL DUTCH SHELL-B |
BRBY.L | BURBERRY GROUP | REL.L | REED ELSEVIER PLC |
BSY.L | B SKY B GROUP | REX.L | REXAM |
BT-A.L | BT GROUP | RIO.L | RIO TINTO |
CCL.L | CARNIVAL | RR.L | ROLLS-ROYCE HLDGS |
CNA.L | CENTRICA | RRS.L | RANDGOLD RESOURCES |
CPG.L | COMPASS GROUP | RSA.L | RSA INSUR GRP |
CPI.L | CAPITA | RSL.L | RESOLUTION NPV |
CRDA.L | CRODA INTL PLC | SAB.L | SABMILLER |
CRH.L | CRH PLC | SBRY.L | SAINSBURY |
CSCG.L | CAP SHOP CENTRES | SDR.L | SCHRODERS |
DGE.L | DIAGEO | SDRC.L | SCHRODERS NVTG |
EMG.L | MAN GROUP | SGE.L | SAGE GRP |
ENRC.L | EURASIAN NATURAL | SHP.L | SHIRE |
EVR.L | EVRAZ | SL.L | STANDARD LIFE |
EXPN.L | EXPERIAN | SMIN.L | SMITHS GROUP |
FRES.L | FRESNILLO | SN.L | SMITH & NEPHEW |
GFS.L | G4S | SRP.L | SERCO GROUP |
GKN.L | GKN | SSE.L | SSE |
GLEN.L | GLENCORE INTL | STAN.L | STANDARD CHARTERED |
GSK.L | GLAXOSMITHKLINE | SVT.L | SEVERN TRENT |
HL.L | HARGREAVES LANS | TATE.L | TATE & LYLE |
HMSO.L | HAMMERSON REIT | TLW.L | TULLOW OIL |
HSBA.L | HSBC HLDG | TSCO.L | TESCO PLC |
IAG.L | INTL. CONS. AIR GRP | ULVR.L | UNILEVER |
IAP.L | ICAP | UU.L | UNITED UTILITIES GR |
IHG.L | INTERCONT HOTELS | VED.L | VEDANTA RESOURCES |
IMI.L | IMI PLC | VOD.L | VODAFONE GRP |
IMT.L | IMPERIAL TOBACCO | WEIR.L | WEIR GROUP |
IPR.L | INTERNATIONAL POWER | WOS.L | WOLSELEY |
ITRK.L | INTERTEK GROUP | WPP.L | WPP |
ITV.L | ITV | WTB.L | WHITBREAD |
XTA.L | XSTRATA |
// url $rss_url = 'https://spreadsheets.google.com/feeds/list/0AhySzEddwIC1dEtpWF9hQUhCWURZNEViUmpUeVgwdGc/1/public/basic?alt=rss'; // get the complete rss feed $rss_result= file_get_contents($rss_url); // create empty array to store results of regex match, gets overwritten each time $preg_match_result_array = array(); // create empty array to store all the array items once extracted by the loop $complete_preg_match_result_array = array(); // split rss feed into items, another array, split by 'item' tag $rss_array = explode('- ',$rss_result); // print_r($array); use this if you want to see how that looks // loop over rss items array and extract the required values using a regex, // to understand better what this is doing take a look at the output of the print_r on the line above foreach($rss_array as $key => $value) { // extract the title and description from the string, store results in $preg_match_result_array preg_match('/.*name:\s+(.*),\s+price:\s+(.*),\s+change:\s+(.*)/', $value, $preg_match_result_array); // push extracted fields array into permemnent array $complete_preg_match_result_array[] = $preg_match_result_array; } // now we have a tidy, multidimensional array with the fields we want // do a // print_r($complete_preg_match_result_array); // to see the structure // if you want to extract more/different fields, modify the regex. each capturing group e.g. (.*) is pushed into the array // now we can loop over the results array and print the values nicely print ' <table class="table table-striped table-bordered table-condensed"> <tr> <td>Company </td> <td>Price </td> <td>Change </td> '; foreach($complete_preg_match_result_array as $key => $value) { print ' <tr> <td>'.$value[1].' </td> <td>'.$value[2].' </td> <td>'.$value[3].' </td> </tr> '; } print ' </table>'; ?>
Company |
Price |
Change |
ANGLO AMERICAN | 2674 | 48 |
ASSOCIAT BRIT FOODS | 2294 | 28 |
ADMIRAL GROUP | 2928 | 10 |
ABERDEEN ASSET MGMT | #N/A | #N/A |
AGGREKO | 660 | 20.5 |
AMEC | #N/A | #N/A |
ANTOFAGASTA | 1541 | 30 |
ARM HOLDINGS | #N/A | #N/A |
ASHMORE GRP | 448.6 | 6.4 |
AVIVA | 344.77 | -1.33 |
ASTRAZENECA | 7713.14 | -8.86 |
BAE SYSTEMS | 483.5 | -2.3 |
BARCLAYS | 144.82 | -2.04 |
BRIT AMER TOBACCO | 2731.5 | -8.5 |
BG GROUP | #N/A | #N/A |
BRIT LAND CO REIT | 444.1 | -3.9 |
BHP BILLITON | #N/A | #N/A |
BUNZL | 2411 | -19 |
BP | 300.85 | -0.4 |
BURBERRY GROUP | 1750.5 | 12.5 |
B SKY B GROUP | #N/A | #N/A |
BT GROUP | 136.69 | -1.42 |
CARNIVAL | 1309.86 | -2.64 |
CENTRICA | 50.98 | 0.58 |
COMPASS GROUP | 1384 | -14.5 |
CAPITA | 37.61 | 0.86 |
CRODA INTL PLC | 6286.57 | -17.43 |
CRH PLC | 3276 | -2 |
CAP SHOP CENTRES | #N/A | #N/A |
DIAGEO | 2925.63 | -0.87 |
MAN GROUP | 150.95 | 2.05 |
EURASIAN NATURAL | #N/A | #N/A |
EVRAZ | 519.69 | 15.89 |
EXPERIAN | 2644 | -35 |
FRESNILLO | 1095 | 18.5 |
G4S | 258.15 | -0.05 |
GKN | #N/A | #N/A |
GLENCORE INTL | 280.55 | 6.8 |
GLAXOSMITHKLINE | 1391.6 | -18.8 |
HARGREAVES LANS | 1624.5 | 24.5 |
HAMMERSON REIT | 22.63 | 0.18 |
HSBC HLDG | 406.65 | -4.8 |
INTL. CONS. AIR GRP | 158.9 | -0.75 |
ICAP | #N/A | #N/A |
INTERCONT HOTELS | 4832 | -26 |
IMI PLC | 1290.72 | 23.72 |
IMPERIAL TOBACCO | #N/A | #N/A |
INTERNATIONAL POWER | #N/A | #N/A |
INTERTEK GROUP | 5540 | 44 |
ITV | 108.8 | -0.35 |
JOHNSON MATTHEY PLC | 2864 | 127 |
KAZAKHMYS | 743.8 | 16.6 |
KINGFISHER | 264.4 | 2 |
LAND SEC R.E.I.T. | 647.4 | -7.4 |
LEGAL & GENERAL | 266.2 | -1.7 |
LLOYDS BANKING GRP | 35.11 | -0.89 |
MEGGITT | 429.1 | 2.7 |
MARKS & SPENCER | 135.6 | 1.2 |
MORRISON SUPERMKTS | 181.1 | 0 |
NATIONAL GRID | 863.48 | -15.32 |
NEXT | 8022 | 38 |
OLD MUTUAL | #N/A | #N/A |
PETROFAC | 111.4 | 0.8 |
POLYMETAL INTL | 1671 | 33.5 |
PRUDENTIAL | 1417 | -17.5 |
PEARSON | 724.6 | 45.6 |
RECKITT BENCK GRP | 6228 | 4 |
ROYAL BK SCOTL GR | #N/A | #N/A |
ROYAL DUTCH SHELL-B | 1404.2 | -8 |
REED ELSEVIER PLC | 1819.5 | -3.5 |
REXAM | #N/A | #N/A |
RIO TINTO | 5999 | 82 |
ROLLS-ROYCE HLDGS | 104.83 | 0.18 |
RANDGOLD RESOURCES | #N/A | #N/A |
RSA INSUR GRP | 676.4 | 0.2 |
RESOLUTION NPV | #N/A | #N/A |
SABMILLER | #N/A | #N/A |
SAINSBURY | 239.7 | 1.5 |
SCHRODERS | 3458 | 26 |
SCHRODERS NVTG | 2289.7 | 14.7 |
SAGE GRP | 564.8 | 4.6 |
SHIRE | #N/A | #N/A |
STANDARD LIFE | #N/A | #N/A |
SMITHS GROUP | 1513 | 16.5 |
SMITH & NEPHEW | 1654.5 | 30.5 |
SERCO GROUP | 122.95 | -1.25 |
SSE | 1501.58 | -15.42 |
STANDARD CHARTERED | 461.9 | -14.7 |
SEVERN TRENT | 2321 | -9 |
TATE & LYLE | 660.4 | -3 |
TULLOW OIL | 34.06 | 0.16 |
TESCO PLC | 242.1 | 0 |
UNILEVER | 4341 | -40 |
UNITED UTILITIES GR | 926 | -3.2 |
VEDANTA RESOURCES | #N/A | #N/A |
VODAFONE GRP | 126.92 | -0.08 |
WEIR GROUP | 1985.5 | 21 |
WOLSELEY | #N/A | #N/A |
WPP | 796.6 | 6.8 |
WHITBREAD | 3106 | 3 |
XSTRATA | #N/A | #N/A |