Ask Price

The price at which a shareholder is willing to part with his or her share. The price that this function returns is 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 and ETFs 'Ask price' can be obtained using this function.


Stocks ETFs Options 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!