We'd like to remind Forumites to please avoid political debate on the Forum... Read More »
We're aware that some users are experiencing technical issues which the team are working to resolve. See the Community Noticeboard for more info. Thank you for your patience.
📨 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?
Options
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 -
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
-
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
-
Albermarle said:greatkingrat said: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
- 350.9K Banking & Borrowing
- 253.1K Reduce Debt & Boost Income
- 453.5K Spending & Discounts
- 243.9K Work, Benefits & Business
- 598.7K Mortgages, Homes & Bills
- 176.9K Life & Family
- 257.1K Travel & Transport
- 1.5M Hobbies & Leisure
- 16.1K Discuss & Feedback
- 37.6K Read-Only Boards