Function
Category
Description
Examples
Function
EMF.YF.Price(symbol or option)
Category
Option, Stock
Description
Current mid price.
Examples
=EMF.YF.Price("AAPL")
=EMF.YF.Price("AAPL210219P00135000")
Function
EMF.YF.Change(symbol or option)
Category
Option, Stock
Description
Change in price today.
Examples
=EMF.YF.Change("AAPL")
=EMF.YF.Change("AAPL210219P00135000")
Function
EMF.YF.ChangePercent(symbol or option)
Category
Option, Stock
Description
Percentage change in price today.
Examples
=EMF.YF.ChangePercent("AAPL")
=EMF.YF.ChangePercent("AAPL210219P00135000")
Function
EMF.YF.PrevClose(symbol)
Category
Stock
Description
Previous market close price.
Examples
=EMF.YF.PrevClose("AAPL")
Function
EMF.YF.Open(symbol)
Category
Stock
Description
Market open price.
Examples
=EMF.YF.Open("AAPL")
Function
EMF.YF.Bid(symbol)
Category
Stock
Description
Current bid price.
Examples
=EMF.YF.Bid("AAPL")
Function
EMF.YF.BidSize(symbol)
Category
Stock
Description
Current bid size.
Examples
=EMF.YF.BidSize("AAPL")
Function
EMF.YF.Ask(symbol)
Category
Stock
Description
Current ask price.
Examples
=EMF.YF.Ask("AAPL")
Function
EMF.YF.AskSize(symbol)
Category
Stock
Description
Current ask size.
Examples
=EMF.YF.AskSize("AAPL")
Function
EMF.YF.Volume(symbol or option)
Category
Option, Stock
Description
Volume of shares traded today.
Examples
=EMF.YF.Volume("AAPL")
=EMF.YF.Volume("AAPL210219P00135000")
Function
EMF.YF.Low(symbol)
Category
Stock
Description
Day low.
Examples
=EMF.YF.Low("AAPL")
Function
EMF.YF.High(symbol)
Category
Stock
Description
Day high.
Examples
=EMF.YF.High("AAPL")
Function
EMF.YF.AverageDailyVolume10Day(symbol)
Category
Stock
Description
Average daily volume over past 10 trading days.
Examples
=EMF.YF.AverageDailyVolume10Day("AAPL")
Function
EMF.YF.AverageDailyVolume3Month(symbol)
Category
Stock
Description
Average daily volume over past 3 months.
Examples
=EMF.YF.AverageDailyVolume3Month("AAPL")
Function
EMF.YF.MarketCap(symbol)
Category
Stock
Description
Current market capitalization.
Examples
=EMF.YF.MarketCap("AAPL")
Function
EMF.YF.ExDividendDate(symbol)
Category
Stock
Description
Ex Dividend Date.
Examples
=EMF.YF.ExDividendDate("AAPL")
Function
EMF.YF.Root(option)
Category
Option
Description
Option contract root.
Examples
=EMF.YF.Root("AAPL210219P00135000")
Function
EMF.YF.Expiry(option)
Category
Option
Description
Option contract expiration date.
Examples
=EMF.YF.Expiry("AAPL210219P00135000")
Function
EMF.YF.Strike(option)
Category
Option
Description
Option contract strike price.
Examples
=EMF.YF.Strike("AAPL210219P00135000")
Function
EMF.YF.OptionType(option)
Category
Option
Description
Option contract type (Call or Put).
Examples
=EMF.YF.OptionType("AAPL210219P00135000")
Function
EMF.YF.OptionLookup(symbol, expiryIndex, priceSpot, priceIndex, optionType)
Category
Option
Description
Option lookup.
Examples
=EMF.YF.OptionLookup("AAPL", 1, 100.5, 10, "C")
Function
EMF.YF.ServerStats(field)
Category
Misc
Description
Show server stats. Available fields: lastUpdateTime, serverTime, marketDate, marketState, sessionId, version.
Examples
=EMF.YF.ServerStats("lastUpdateTime")
=EMF.YF.ServerStats("serverTime")
=EMF.YF.ServerStats("marketDate")
=EMF.YF.ServerStats("sessionId")