How can I trade in Excel, like placing buy or sell order?

Answer 1

Microsoft Excel is a spreadsheet application, not a portal to an online broker, therefore you cannot make trades directly using Excel.

You can, however, use an Excel workbook to maintain your portfolio and do all sorts of analytics. Also, you can use web queries to download real-time price data so that you can monitor stocks and market indices.

Finally, financial databases (which require a subscription) like Bloomberg or Morningstar Direct have Excel APIs where you can create DDE-linked workbooks that can query real-time data directly from the databases.

Good luck to you with your investing endeavors.