Sample Account Media Service Formulas

Create formula links to web and news services, such as Bloomberg, Google, or Yahoo, based on account names or financial ticker symbols.

Available in: both Salesforce Classic and Lightning Experience

Available in: Essentials, Group, Professional, Enterprise, Performance, Unlimited, and Developer Editions

For details about using the functions included in these samples, see Formula Operators and Functions by Context.

BBC™ News Search

This formula creates a link to a BBC news search site based on the Account Name.

HYPERLINK(
"http://www.bbc.co.uk/search/news/?q="&Name, 
"BBC News")

This formula creates a link to an account's ticker symbol on the Bloomberg website.

HYPERLINK(
"http://www.bloomberg.com/markets/symbolsearch?query="&TickerSymbol, 
"Bloomberg News")

This formula creates a link to a CNN news search site using the Account Name.

HYPERLINK(
"http://www.cnn.com/search/?query="&Name,
"CNN News")

This formula creates a link to an account's ticker symbol on the Marketwatch.com website.

HYPERLINK(
"http://www.marketwatch.com/investing/stock/"&TickerSymbol,
"Marketwatch")

This formula creates a link to a Google search site using the Account Name.

HYPERLINK(
"http://www.google.com/#q="&Name, 
"Google")

This formula creates a link to a Google news search site using the Account Name.

HYPERLINK(
"http://news.google.com/news/search?en&q="&Name, 
"Google News")

This formula creates a link to a Yahoo! search site using the Account Name.

HYPERLINK(
"http://search.yahoo.com/search?p="&Name, 
"Yahoo Search")

This formula creates a link to a Yahoo! news search site using the Account Name.

HYPERLINK(
"http://news.search.yahoo.com/search/news?p="&Name, 
"Yahoo News")