LastTradeSize – Quickly Retrieve the Most Recent Trade Size

The LastTradeSize function in MarketXLS helps you access the latest trade size for a specific stock symbol. By simply entering a ticker symbol, you can see how large the most recent trade was on the market. This feature is particularly useful for active traders and investors who want near real-time insight into market activity.

Why Use This Function?

• Quickly Gauge Market Volume: LastTradeSize shows the exact size of the most recent trade, giving you immediate insight into trading momentum.
• Perfect for Intraday Analysis: If you are monitoring a stock multiple times a day, each new trade size helps you see short-term trading activity.
• Tracking Liquidity: Understanding if trades are happening in small or large quantities helps measure supply and demand levels for a particular stock.
• Simple & Straightforward: This single-parameter function is easy to set up in your Excel models with just the ticker symbol.

How to Use in Excel

=LastTradeSize("Symbol")

1. Type =LastTradeSize into any cell in Excel.
2. Provide the stock’s ticker symbol as a string within quotes, e.g., "AAPL".
3. Press Enter to retrieve the size of the stock’s latest trade.

After you press Enter, MarketXLS contacts its data service to fetch the most recent trade size. If you have a valid license and a correct symbol, the cell will immediately display the result.

Parameters Explained

Notes on Output:
• Returns an integer or text representing the size of the latest trade.
• In certain cases, you may see "Refreshing" if data is in the process of updating.
• Returns "NA" if an unexpected error occurs or if the symbol is incorrect.

Example Usage

Basic Examples

1. =LastTradeSize("MSFT")

   • This instantly shows the size of Microsoft’s most recent trade. If the symbol is correct and your license is valid, you’ll see an integer output—like 100 or 200 shares.

2. =LastTradeSize("TSLA")

   • Perfect for monitoring daily fluctuations in Tesla’s trade sizes.

Advanced Scenarios

• Using Dynamic References:

• Enter a symbol in cell A1 (e.g., A1 = "AMZN").
• In another cell: =LastTradeSize(A1)
• This allows you to change the value in A1 (e.g., "MSFT") and dynamically retrieve the last trade size for any ticker without updating your formula.

• Integrating with Other MarketXLS Functions:

• Combine =LastTradeSize("AAPL") with other MarketXLS metrics like last trade price or open/close data to create a comprehensive trading dashboard.
• Useful for building real-time or near real-time watchlists and tracking multiple symbols side by side.

Common Questions and Troubleshooting

1. Why am I getting "NA"?

   • Possible reasons include an invalid ticker symbol, an expired license, or a temporary issue fetching data. Double-check your symbol and ensure your MarketXLS license is active.

2. Why do I see "Refreshing"?

   • When the data is being refreshed on the server side, MarketXLS places your request in a waitlist and returns “Refreshing” for that short period. The cell automatically updates when new data is available.

3. Can I use LastTradeSize in Trading Strategies?

   • Absolutely. You can incorporate LastTradeSize alongside other indicators (e.g., RSI, moving averages) in Excel-based trading models to spot large-volume trades or sudden surges that might affect entry/exit decisions.

Remember:

• Double-check your ticker symbols and license validity for accurate results.
• Use LastTradeSize in tandem with other data points to paint a comprehensive market picture.
• Experiment with dynamic references and advanced formulas for powerful Excel-based stock analysis, leveraging the combined benefits of MarketXLS data feeds and Excel’s flexibility.

By staying mindful of these guidelines and examples, you’ll confidently integrate the LastTradeSize function into your Excel models for more informed, data-driven trading decisions.