FTSE100 Data Feed, Free & (almost) real time!

A free and (almost) real time feed of all FTSE100 companies, including price and change since previous close of trading price.

View current FTSE100 Feed View data in Google Docs

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>

Complete data feed


A complete feed of the dataset can be requested via the following request;

XML(ATOM)

https://spreadsheets.google.com/feeds/list/0AhySzEddwIC1dEtpWF9hQUhCWURZNEViUmpUeVgwdGc/1/public/basic Try it

JSON-P

https://spreadsheets.google.com/feeds/list/0AhySzEddwIC1dEtpWF9hQUhCWURZNEViUmpUeVgwdGc/1/public/basic?alt=json-in-scriptTry it

JSON

https://spreadsheets.google.com/feeds/list/0AhySzEddwIC1dEtpWF9hQUhCWURZNEViUmpUeVgwdGc/1/public/basic?alt=json Try it

RSS

https://spreadsheets.google.com/feeds/list/0AhySzEddwIC1dEtpWF9hQUhCWURZNEViUmpUeVgwdGc/1/public/basic?alt=rss Try it


Query Feed


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.

List of available companies and symbols


Symbol

Company Name

Symbol

Company Name

AAL.LANGLO AMERICANJMAT.LJOHNSON MATTHEY PLC
ABF.LASSOCIAT BRIT FOODSKAZ.LKAZAKHMYS
ADM.LADMIRAL GROUPKGF.LKINGFISHER
ADN.LABERDEEN ASSET MGMTLAND.LLAND SEC R.E.I.T.
AGK.LAGGREKOLGEN.LLEGAL & GENERAL
AMEC.LAMECLLOY.LLLOYDS BANKING GRP
ANTO.LANTOFAGASTAMGGT.LMEGGITT
ARM.LARM HOLDINGSMKS.LMARKS & SPENCER
ASHM.LASHMORE GRPMRW.LMORRISON SUPERMKTS
AV.LAVIVANG.LNATIONAL GRID
AZN.LASTRAZENECANXT.LNEXT
BA.LBAE SYSTEMSOML.LOLD MUTUAL
BARC.LBARCLAYSPFC.LPETROFAC
BATS.LBRIT AMER TOBACCOPOLY.LPOLYMETAL INTL
BG.LBG GROUPPRU.LPRUDENTIAL
BLND.LBRIT LAND CO REITPSON.LPEARSON
BLT.LBHP BILLITONRB.LRECKITT BENCK GRP
BNZL.LBUNZLRBS.LROYAL BK SCOTL GR
BP.LBPRDSB.LROYAL DUTCH SHELL-B
BRBY.LBURBERRY GROUPREL.LREED ELSEVIER PLC
BSY.LB SKY B GROUPREX.LREXAM
BT-A.LBT GROUPRIO.LRIO TINTO
CCL.LCARNIVALRR.LROLLS-ROYCE HLDGS
CNA.LCENTRICARRS.LRANDGOLD RESOURCES
CPG.LCOMPASS GROUPRSA.LRSA INSUR GRP
CPI.LCAPITARSL.LRESOLUTION NPV
CRDA.LCRODA INTL PLCSAB.LSABMILLER
CRH.LCRH PLCSBRY.LSAINSBURY
CSCG.LCAP SHOP CENTRESSDR.LSCHRODERS
DGE.LDIAGEOSDRC.LSCHRODERS NVTG
EMG.LMAN GROUPSGE.LSAGE GRP
ENRC.LEURASIAN NATURALSHP.LSHIRE
EVR.LEVRAZSL.LSTANDARD LIFE
EXPN.LEXPERIANSMIN.LSMITHS GROUP
FRES.LFRESNILLOSN.LSMITH & NEPHEW
GFS.LG4SSRP.LSERCO GROUP
GKN.LGKNSSE.LSSE
GLEN.LGLENCORE INTLSTAN.LSTANDARD CHARTERED
GSK.LGLAXOSMITHKLINESVT.LSEVERN TRENT
HL.LHARGREAVES LANSTATE.LTATE & LYLE
HMSO.LHAMMERSON REITTLW.LTULLOW OIL
HSBA.LHSBC HLDGTSCO.LTESCO PLC
IAG.LINTL. CONS. AIR GRPULVR.LUNILEVER
IAP.LICAPUU.LUNITED UTILITIES GR
IHG.LINTERCONT HOTELSVED.LVEDANTA RESOURCES
IMI.LIMI PLCVOD.LVODAFONE GRP
IMT.LIMPERIAL TOBACCOWEIR.LWEIR GROUP
IPR.LINTERNATIONAL POWERWOS.LWOLSELEY
ITRK.LINTERTEK GROUPWPP.LWPP
ITV.LITVWTB.LWHITBREAD
XTA.LXSTRATA
	
// 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 1310.55 4.55
ASSOCIAT BRIT FOODS 3189.71 9.71
ADMIRAL GROUP 1962.82 -7.18
ABERDEEN ASSET MGMT 316.33 0
AGGREKO 858.92 4.42
AMEC #N/A #N/A
ANTOFAGASTA 993.48 19.98
ARM HOLDINGS 0 #N/A
ASHMORE GRP 360.67 2.67
AVIVA 518.85 -2.65
ASTRAZENECA 4500.74 66.74
BAE SYSTEMS 592 -3.5
BARCLAYS 192.79 -0.51
BRIT AMER TOBACCO 4731.08 -41.92
BG GROUP 0 #N/A
BRIT LAND CO REIT 605 -5.5
BHP BILLITON 1410.37 15.87
BUNZL 2345.1 4.1
BP 442.43 0.23
BURBERRY GROUP 1771.37 -15.63
B SKY B GROUP #N/A #N/A
BT GROUP 292.97 0.02
CARNIVAL 5345 -20
CENTRICA 199.75 -1.15
COMPASS GROUP 1647.68 -6.32
CAPITA 646.44 -0.06
CRODA INTL PLC 3873.62 10.62
CRH PLC 2690 -9
CAP SHOP CENTRES #N/A #N/A
DIAGEO 2575.42 -4.58
MAN GROUP 167.58 0.58
EURASIAN NATURAL 0 #N/A
EVRAZ 289.17 18.17
EXPERIAN 1521.86 -2.14
FRESNILLO 1563.86 23.86
G4S 294 -0.5
GKN 321.87 1.87
GLENCORE INTL 353.1 4.5
GLAXOSMITHKLINE 1516.86 12.86
HARGREAVES LANS 1349.88 9.88
HAMMERSON REIT 563.45 -1.55
HSBC HLDG 740.83 -0.77
INTL. CONS. AIR GRP 612.95 -1.55
ICAP 0 #N/A
INTERCONT HOTELS 3856.77 -46.23
IMI PLC 1160.8 -3.2
IMPERIAL TOBACCO #N/A #N/A
INTERNATIONAL POWER 417.7 #N/A
INTERTEK GROUP 4914.14 -2.86
ITV 163.29 -2.41
JOHNSON MATTHEY PLC 2823.75 14.75
KAZAKHMYS 793.43 9.43
KINGFISHER 298.77 1.27
LAND SEC R.E.I.T. 1005 -8
LEGAL & GENERAL 262.81 -1.39
LLOYDS BANKING GRP 65.39 0.35
MEGGITT 511.27 13.77
MARKS & SPENCER 321.13 1.93
MORRISON SUPERMKTS 252.88 3.78
NATIONAL GRID 972.36 0.26
NEXT 4150.3 -24.7
OLD MUTUAL 205.9 -0.2
PETROFAC 440.09 -2.21
POLYMETAL INTL 915.91 -6.09
PRUDENTIAL 1810.84 -6.66
PEARSON 615.19 -6.31
RECKITT BENCK GRP 7357.36 25.36
ROYAL BK SCOTL GR 255.79 1.79
ROYAL DUTCH SHELL-B 2166.12 15.62
REED ELSEVIER PLC 1688.16 0.16
REXAM 0 #N/A
RIO TINTO 3571.72 32.22
ROLLS-ROYCE HLDGS 916.92 -0.08
RANDGOLD RESOURCES 7568.98 18.98
RSA INSUR GRP 656.66 -6.84
RESOLUTION NPV #N/A #N/A
SABMILLER 0 #N/A
SAINSBURY 236.88 -0.82
SCHRODERS 3376.91 -15.09
SCHRODERS NVTG 2447.28 -12.72
SAGE GRP 697.94 -2.56
SHIRE 3741 16
STANDARD LIFE #N/A #N/A
SMITHS GROUP 1565.09 -11.91
SMITH & NEPHEW 1385.72 -0.28
SERCO GROUP 108.89 0.09
SSE 1439.05 -1.95
STANDARD CHARTERED 767 1.8
SEVERN TRENT 2247.8 -9.2
TATE & LYLE 685.44 -2.06
TULLOW OIL 158.27 -2.03
TESCO PLC 184.78 0.58
UNILEVER 4507.13 -8.37
UNITED UTILITIES GR 910.97 -2.03
VEDANTA RESOURCES 808.5 31.5
VODAFONE GRP 220.69 -0.46
WEIR GROUP 1764.84 13.84
WOLSELEY #N/A #N/A
WPP 1434.8 -159.2
WHITBREAD 3800.66 -50.34
XSTRATA 0 #N/A