A new API family at acc.ejiapi.com. A read-only agent on your TallyPrime PC syncs the companies you choose, and you read ledger balances, statements, trial balance, receivables and stock through an API or Google Sheets formulas, even when that PC is off. Now in beta for CAs and businesses.
New site acc.ejiapi.com with the Tally API: ledgers, balances on any date, ledger statements, trial balance, group totals, day book, bill-wise receivables and payables, and stock.
22 Google Sheets formulas such as =TALLY_BALANCE("Cash"), =TALLY_OUTSTANDING("Ravi Traders") and =TALLY_TRIAL_BALANCE(); a whole column of balances comes in one request.
The EJI Tally Agent for Windows: link it with a pairing code, connect or disconnect each company, and only changes are uploaded after the first sync. It never changes anything in Tally.
Accounting keys (acc_) are separate from finance keys and can be limited to one company.
Month-end holdings for October 2026 are now in for 30 fund houses, and Kotak, Aditya Birla Sun Life and Sundaram load automatically from now on instead of by hand. Union Mutual Fund, which was missing, is back.
Holdings now cover about 79% of the open-ended equity and hybrid funds (618 of 780); October 2026 is loaded for almost all of them.
Kotak, Aditya Birla Sun Life and Sundaram month-end portfolios are picked up automatically within hours of the fund house publishing them.
Union Mutual Fund (18 funds) was not loading because its site rejected the availability check; fixed.
Still loaded by hand each month: ICICI Prudential, Axis, Edelweiss, Mahindra Manulife and a few small fund houses.
The Google Sheets script from the Sheets Lab now tests your connection when you set your key and tells you exactly what is wrong, instead of leaving a sheet full of #ERROR!. Refresh values is also safer, and the steps explain Google's "unverified app" prompt.
EJI API > Set API key now tests the connection straight away and shows the result: it works, the key was not accepted, the rate limit was reached, or Google's permission is missing.
New EJI API > Check setup runs the same test any time.
Build my portfolio sheet now stops with a clear message when the connection does not work, instead of building a sheet of errors.
Refresh values now re-enters only the EJI formulas (FUNDNAV, FUNDNAME, NAVON, NAVRETURN) and leaves everything else alone: your typed cells (text like 007 or 1/2 is no longer turned into a number or a date) and your other formulas. It really does fetch fresh values, and if something goes wrong halfway the formulas it cleared are put back.
Errors in cells now say what to do, for example to set the key or to run Check setup once to give the script permission.
The steps explain Google's "hasn't verified this app" screen (normal for a script in your own sheet) and what to do when a cell shows #ERROR!.
Every update to the site now has its own entry on one public page, newest first, with a short summary and a picture of the main feature, so you can see at a glance what changed and when.
New page https://fin.ejiapi.com/changelog lists every update with a summary, a picture where there is one, and the full list of changes. Each version has its own link you can share.
The page is linked from the footer of every page and listed in the sitemap.
A public Market news page with SEBI items, company filings and headlines tagged by stock, a morning news digest in this group, and a Sheets Lab in the Mutual Fund Explorer that turns your portfolio into a ready Google Sheet.
A market-news digest is now posted here every morning at 8:00 am IST, silently, covering the last 24 hours in a few messages: SEBI items, the company filings that matter most (board outcomes and results, orders, acquisitions, ratings, record dates) and headlines from Mint, Business Standard, Economic Times and The Hindu BusinessLine, tagged with #SYMBOL. Anything beyond the daily caps is counted at the end and stays in the explorer.
New public page https://fin.ejiapi.com/market/news: all the news in one managed view, grouped by day, with tabs for Top stories, Market news, SEBI and Company filings, a page for each stock (/market/news?symbol=RELIANCE), and a link to the original source on every story. It is a normal web page that search engines can read, and it is linked from the Market Data menu.
New Sheets Lab tab in the Mutual Fund Explorer: try spreadsheet formulas on live fund data (FUNDNAV, FUNDNAME, NAVON, NAVRETURN, XIRR, IF, IFERROR, SUM and more) and keep a small portfolio (add purchases or import a CSV) to see value, gain, XIRR and allocation by fund and category. Your grid and portfolio stay in your browser.
Take it to Google Sheets in a few clicks: one copied script adds the fund formulas and an EJI API menu to your sheet (Set API key, Build my portfolio sheet, Refresh values) and builds your portfolio into a sheet with the formulas already in it, XIRR included. Or copy the portfolio table or the grid cells and paste them into cell A1.
GET /api/market/news now includes those publishers' headlines with a short teaser and link, and a dateOnly flag for sources that give a date but no time (SEBI). The Explorer shows news times in IST.
Search any NSE or BSE stock in the Market Explorer and see its price chart, delivery data, corporate actions, deals and news. Price history now goes back to October 2025.
Market Explorer has a new Stocks tab: search any NSE stock by symbol or company name, see its close, change, ranges, delivery %, a price chart, recent sessions, corporate actions and bulk/block deals.
Stocks now cover every NSE main-board and SME stock and every BSE-listed security (about 5,000, all groups), so BSE-only names such as SpiceJet are found. Search shows which exchange a stock is on; equity/{symbol}/history takes series=ALL and falls back to BSE for symbols NSE does not carry.
Daily price history for NSE and BSE stocks now goes back to October 2025 (about 13 months); the chart only offers the ranges the history can fill.
New endpoint GET /api/market/equity/search?q= to find a stock's symbol by name.
New endpoint GET /api/market/news: headlines with source and link from SEBI, NSE corporate announcements and Indian news sites, tagged to NSE symbols (filter by symbol, source, dates). Refreshed every 10 minutes.
