Last Price

The last traded price . This price is delayed by 15 minutes.

How calculated

No Calculations

Example usage



This is the default function and does not need any addon. All US and Canadian stocks, Cryptocurrencies and ETFs 'Last price' can be obtained using this function.


Stocks ETFs Options Mutual Funds Indices Currencies Cryptocurrencies

Stand with Ukraine

As the situation in Ukraine escalates, many of us in MarketXLS are left with emotions too overwhelming to name. If you’d like to show your support, but aren’t sure how to, we want to help make it easier for you to act.

For any amount donated, we’ll extend your MarketXLS subscription for double of the donated amount. Please send proof of your payment to to avail the extention

From all of us at MarketXLS, thank you!