We’d like to remind Forumites to please avoid political debate on the Forum.
This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
Alternative to BBC market data page?
Comments
-
I have set up a google sheet using:
=googlefinance("INDEXFTSE:MCX","price") for most and a YH finance add in for others =YHFINANCE_QUOTES("BZ=F")
Can also have previous day price to have % change column
Only one I haven't found a ticker for is UK ICE natural Gas, have added gold and bitcoin as extras and reduced coverage of European and Asian bourses.
GoogleFinance:UK Markets INDEXFTSE:UKX INDEXFTSE:MCX Europe Markets INDEXEURO:AEX INDEXEURO:PX1 INDEXDB:DAX INDEXSTOXX:SX5E INDEXBME:INDI US Markets INDEXDJX:.DJI INDEXNASDAQ:.IXIC INDEXSP:.INX Asia Markets INDEXBOM:SENSEX INDEXHANGSENG:HSI INDEXNIKKEI:NI225 Currency CURRENCY:GBPUSD CURRENCY:GBPEUR
YHFINANCE_QUOTESBZ=F CL=F GC=F BTC-USD I think....2 -
Can you find the price for gilts, eg TR43?michaels said:I have set up a google sheet using:
=googlefinance("INDEXFTSE:MCX","price") for most and a YH finance add in for others =YHFINANCE_QUOTES("BZ=F")
Can also have previous day price to have % change column
Only one I haven't found a ticker for is UK ICE natural Gas, have added gold and bitcoin as extras and reduced coverage of European and Asian bourses.
GoogleFinance:UK Markets INDEXFTSE:UKX INDEXFTSE:MCX Europe Markets INDEXEURO:AEX INDEXEURO:PX1 INDEXDB:DAX INDEXSTOXX:SX5E INDEXBME:INDI US Markets INDEXDJX:.DJI INDEXNASDAQ:.IXIC INDEXSP:.INX Asia Markets INDEXBOM:SENSEX INDEXHANGSENG:HSI INDEXNIKKEI:NI225 Currency CURRENCY:GBPUSD CURRENCY:GBPEUR
YHFINANCE_QUOTESBZ=F CL=F GC=F BTC-USD 0 -
There is a search box here for Yahoo finance 'tickers'
Symbol Lookup from Yahoo Finance
and for google finance
Google Finance – Stock-market prices, real-time quotes and business news
Found this for HSBC global but it is an ETF in USD, you could obviously fix the USD bit using the exchange rate
HMWO:LONI think....1 -
I've found this add-on useful for getting data for funds in to a Google sheet
https://workspace.google.com/marketplace/app/%C2%B5funds/274036499952
For example, once installed:
=muFunds("nav","GB00B3TYHH97")
returns the latest price for Vanguard LifeStrategy 60 Acc.
ISIN code(s) can obviously be stored in separate cell(s) and referred to in the function if preferred.
2 -
One more alternative I find for 'at a glance' summary of which major markets are going up/down: Stock Market Index - Major World Indices Live - Investing.com UK0
-
Too many adverts keep popping up . They have a Black Friday sale. Unusual for an investing site !SteveBLFC64 said:One more alternative I find for 'at a glance' summary of which major markets are going up/down: Stock Market Index - Major World Indices Live - Investing.com UK0 -
I’d say that the markets page is accessed less than the footy or horses. People, on this page (me included) are atypical. It’s a judgement, I don’t think it’s a bad one.Albermarle said:
Plus they still publish horse racing results ( quite quickly in fact) despite numerous other places to look.greatkingrat said:
There are hundreds of sources for the Premier League table, but the BBC still show it!pterri said:Seems a reasonable cost cut, there are hundreds of sources of info for the markets, no need for the bbc to replicate it.1 -
The BBC has ‘Public Purposes’ to deliver on. https://www.bbc.co.uk/aboutthebbc/governance/mission
I guess provision of market information would fit in the first, but if the same information is available through other impartial sources then it shouldn’t be as high a priority.
I suppose the next question is whether sports should be a priority!
Fashion on the Ration
2024 - 43/66 coupons used, carry forward 23
2025 - 62/890
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 352.9K Banking & Borrowing
- 253.9K Reduce Debt & Boost Income
- 454.7K Spending & Discounts
- 246K Work, Benefits & Business
- 602K Mortgages, Homes & Bills
- 177.8K Life & Family
- 259.9K Travel & Transport
- 1.5M Hobbies & Leisure
- 16K Discuss & Feedback
- 37.7K Read-Only Boards


