Documentation
HomeGithubDiscordBlog
  • What is OpenAlgo?
  • OpenAlgo Architecture
  • Mini FOSS Universe
  • Community Support
  • OpenAlgo GPT
  • New Features
    • Fast Scalper
    • API Analyzer
    • Traffic/Latency Monitor
    • Chartink Integration
  • Monetization
  • Connect Brokers
    • Brokers
      • 5Paisa
      • 5paisa (XTS)
      • AliceBlue
      • AngelOne
      • Compositedge
      • Dhan
      • Firstock
      • FlatTrade
      • Fyers
      • Groww
      • IIFL (XTS)
      • Jainam Retail (XTS)
      • Jainam Dealer (XTS)
      • Kotak Securities
      • Paytm
      • Pocketful
      • Shoonya
      • Upstox
      • Wisdom Capital
      • Zebu
      • Zerodha
  • Installation Guidelines
  • Getting Started
    • Windows Installation
      • Pre-Requesites
      • Setup
      • Install Dependencies
      • Ngrok Config
      • Environmental Variables
      • Start OpenAlgo
      • SSL Verification Failed
      • Accessing OpenAlgo
    • Windows Server Installation
    • Mac OS Installation
      • Pre-Requesties
      • Setup
      • Install Dependencies
      • Ngrok Config
      • Environmental Variables
      • Start OpenAlgo
      • Install certifi
      • Accessing OpenAlgo
    • Amazon Elastic Beanstalk
    • Ubuntu Server Installation
    • Docker Development
    • Testing OpenAlgo in Cloud
    • Upgrade
  • Latency
  • API Documentation
    • V1
      • Accounts API
        • Funds
        • Orderbook
        • Tradebook
        • PositionBook
        • Holdings
      • Orders API
        • Placeorder
        • PlaceSmartOrder
        • BasketOrder
        • SplitOrder
        • ModifyOrder
        • CancelOrder
        • CancelAllOrder
        • ClosePosition
        • OrderStatus
        • OpenPosition
      • Data API
        • Quotes
        • Depth
        • History
        • Intervals
        • Symbol
        • Ticker
      • Order Constants
      • HTTP Status Codes
      • Rate Limiting
      • API Collections
  • Symbol Format
  • MCP
  • Trading Platform
    • Amibroker
      • AmiQuotes
      • Button Trading Module
      • Button Trading with Split Orders
      • Button Trading with Stoploss
      • SmartOrder Chart Module
      • Trailing Stoploss Execution Module
      • Line Trading Module
      • Equity Exploration Module
      • CSV Exploration Module
      • Options Button Trading Module
      • Spot/Futures to Options Module (Single Leg)
      • Spot/Futures to Options Module (Two Leg)
      • Time Based Execution
    • Tradingview
    • ChartInk
    • Python
      • Strategy Management
      • EMA Crossover Strategy
      • Supertrend Strategy
      • Supertrend Strategy with yfinance data
      • Voice Based Orders
    • NodeJS
    • Metatrader 5
      • Download & Install Library
      • OpenAlgo MQL5 Functions
      • Include the Header File
      • Sample Expert Advisor
    • Excel
    • Google Spreadsheets
    • N8N
    • Chrome Extension
  • Strategy Management
  • Developers
    • Design Documentation
      • Architecture
      • API Layer
      • Broker Integerations
      • Database Layer
      • Authentication Platforms
      • Configuration
      • Utilities
      • Broker Integration Checklist
  • Change Log
    • Version 1.0.0.24 Launched
    • Version 1.0.0.23 Launched
    • Version 1.0.0.22 Launched
    • Version 1.0.0.21 Launched
    • Version 1.0.0.20 Launched
    • Version 1.0.0.19 Launched
    • Version 1.0.0.18 Launched
    • Version 1.0.0.17 Launched
    • Version 1.0.0.16 Launched
    • Version 1.0.0.15 Launched
    • Version 1.0.0.14 Launched
    • Version 1.0.0.13 Launched
    • Version 1.0.0.12 Launched
    • Version 1.0.0.11 Launched
    • Version 1.0.0.10 Launched
    • Version 1.0.0.9 Launched
    • Version 1.0.0.8 Launched
    • Version 1.0.0.7 Launched
    • Version 1.0.0.6 Launched
    • Version 1.0.0.5 Launched
    • Version 1.0.0.4 Launched
    • Version 1.0.0.3 Launched
    • Version 1.0.0.2 Launched
    • Version 1.0.0.1 Launched
    • Version 1.0.0.0 Launched
Powered by GitBook
On this page
  • OpenAlgo Excel Documentation
  • Introduction
  • Install the OpenAlgo - Excel Addins
  • ⚠ .NET 6 Desktop Runtime is Required
  • Configuration
  • Account Functions
  • Market Data Functions
  • Order Functions
  • Notes
  • Support
  1. Trading Platform

Excel

OpenAlgo Excel Documentation

Introduction

OpenAlgo provides seamless integration with Excel for executing trading strategies, fetching market data, and managing orders. This documentation covers the available Excel functions, their usage, and examples.

Install the OpenAlgo - Excel Addins

Before installing OpenAlgo Excel Add-In, ensure you are selecting the correct version based on your Excel installation.

📌 Steps to Check Your Excel Version

  1. Open Microsoft Excel

  2. Click File → Account

  3. Click About Excel

  4. Look for "32-bit" or "64-bit" in the version details.

🔹 Which Version Should You Install?

  • If your Excel version is 64-bit → Install the 64-bit add-in ✅ (Recommended)

  • If your Excel version is 32-bit → Install the 32-bit add-in ✅

Download the OpenAlgo Excel Addin

⚠ .NET 6 Desktop Runtime is Required

OpenAlgo Excel Add-In is built using Excel-DNA, which requires the .NET 6 Desktop Runtime to run add-ins.

🔹 If the add-in is not working or Excel does not recognize it, install the .NET 6 Desktop Runtime from the link below:

✅ After installing the runtime, restart your system and try loading the add-in again.


Configuration

Setting API Key, Version, and Host URL

Function: oa_api(api_key, [version], [host_url])

Example Usage:

=oa_api("your_api_key")
=oa_api("your_api_key", "v1", "http://127.0.0.1:5000")

Parameters:

  • api_key (Mandatory): API Key for authentication

  • version (Optional, default: "v1"): API version


Account Functions

Retrieve Funds

Function: oa_funds()

Example Usage:

=oa_funds()

Returns: A table with available funds and collateral details.


Retrieve Order Book

Function: oa_orderbook()

Example Usage:

=oa_orderbook()

Returns: A table with all open orders.


Retrieve Trade Book

Function: oa_tradebook()

Example Usage:

=oa_tradebook()

Returns: A table with executed trades.


Market Data Functions

Get Market Quotes

Function: oa_quotes(symbol, exchange)

Example Usage:

=oa_quotes("RELIANCE", "NSE")

Returns: Market price details for the given symbol.


Get Market Depth

Function: oa_depth(symbol, exchange)

Example Usage:

=oa_depth("RELIANCE", "NSE")

Returns: Order book depth for buy/sell levels.


Fetch Historical Data

Function: oa_history(symbol, exchange, interval, start_date, end_date)

Example Usage:

=oa_history("RELIANCE", "NSE", "1m", "2024-12-01", "2024-12-31")

Returns: Historical market data in a table format.


Order Functions

Place an Order

Function: oa_placeorder(strategy, symbol, action, exchange, pricetype, product, [quantity], [price], [trigger_price], [disclosed_quantity])

Example Usage:

=oa_placeorder("MyStrategy", "INFY", "BUY", "NSE", "LIMIT", "MIS", 10, 1500, 0, 0)

Parameters:

  • Mandatory: strategy, symbol, action, exchange, pricetype, product

  • Optional: quantity, price, trigger_price, disclosed_quantity


Place a Smart Order

Function: oa_placesmartorder(strategy, symbol, action, exchange, pricetype, product, [quantity], [position_size], [price], [trigger_price], [disclosed_quantity])

Example Usage:

=oa_placesmartorder("SmartStrat", "INFY", "BUY", "NSE", "MARKET", "MIS", 10, "", 0, 0, 0)

Modify an Order

Function: oa_modifyorder(orderid, strategy, symbol, action, exchange, [quantity], [pricetype], [product], [price], [trigger_price], [disclosed_quantity])

Example Usage:

=oa_modifyorder("Strategy", "241700000023457", "RELIANCE", "BUY", "NSE", 1, "LIMIT", "MIS", 2500, 0, 0)

Cancel an Order

Function: oa_cancelorder(orderid, strategy)

Example Usage:

=oa_cancelorder("Strategy", "241700000023457")

Close All Open Positions

Function: oa_closeposition(strategy)

Example Usage:

=oa_closeposition("MyStrategy")

Get Order Status

Function: oa_orderstatus(orderid, strategy)

Example Usage:

=oa_orderstatus("MyStrategy", "241700000023457")

Open a Position

Function: oa_openposition(strategy, symbol, exchange, product)

Example Usage:

=oa_openposition("MyStrategy", "INFY", "NSE", "MIS")

Notes

  • Test in OpenAlgo Analyzer Mode before using in live markets.

Support

PreviousSample Expert AdvisorNextGoogle Spreadsheets

Last updated 2 months ago

➡

host_url (Optional, default: ""): API host URL

For more details, visit .

Download .NET 6 Desktop Runtime
http://127.0.0.1:5000
OpenAlgo Docs
Releases · marketcalls/OpenAlgo-ExcelGitHub
Logo