Spreadsheet and data solutions provider Sourcetable launched a “self-driving” spreadsheet that allows users to simply tell the spreadsheet what they want done through natural language commands.
Sourcetable developed the solution as a way to bring advanced spreadsheet functionality to people who might struggle with basic functions like VLOOKUP or creating a pivot table. The “self-driving” autopilot capabilities give the AI complete write access and edit control to complete multi-step operations.
“AI is the biggest platform shift since the browser, with a bigger opportunity for disruption,” said Sourcetable CEO and co-founder Eoin McMillan. “Sourcetable is building the AI spreadsheet for the next billion users, be they human or AI. As AI makes analysis easier, everybody will become an analyst. Sourcetable’s AI automation ushers in a new era of productivity and human cognition.”
Summit Art Creations – stock.adobe.com
Sourcetable’s autopilot mode can complete a wide range of complex tasks, including creating and editing financial models, generating spreadsheet templates, building pivot tables, cleaning data, creating charts and graphs, editing formatting, enriching data and analyzing entire workbooks. The AI can understand data context without requiring users to pre-select ranges, interpret multiple ranges across different tabs, work with messy data, and seek human clarification when instructions are unclear.
The AI is capable of accessing anything that is publicly available on the internet, McMillan said in an email, and it can also extract data from URLs if instructed to do so. This includes Federal Reserve Economic Data, stock ticks and trading data, Yahoo finance, futures, geopolitics, market sentiment, macroeconomic analyses, Wikipedia data and much more. “There’s even a full fund manager Easter egg included in this release,” he added.
This ability to access tools outside itself also means that users, via a virtual machine with hundreds of libraries and AI tools available, can ask the autopilot to find a more advanced tool to serve their needs by requesting the system to “download data” or “use Python” to solve a task. McMillan said Sourcetable plans to make this feature more user-friendly in the future as the technology ultimately moves toward becoming a full agentic platform and operating system.
To discourage the AI from providing false information, the solution is built around a code-driven evaluation loop developed internally that verifies AI response in real time. Without this foundation, according to Sourcetable, self-driving spreadsheet automation would be too slow and unreliable to be trusted. McMillan said the company uses a combination of techniques to optimize results while minimizing latency. First, there’s AI-driven process supervision of inputs, outputs and prompts, effectively AI watching AI. This is combined with a code-driven audit of quantitative outputs (e.g., Python, SQL and spreadsheet output evaluation) and, finally, thought-driven techniques (e.g., Chain of Thought Reasoning and Deliberate Reasoning) to drive better results, particularly for multi-step processes.
The new solution uses not one but many models to deliver results. While certain companies are locked into their own proprietary AI models, Sourcetable’s AI selects the optimal model for each task–including OpenAI, Anthropic, Groq, Meta (Llama), Nvidia, Prior Labs, DeepSeek and Hugging Face—and even combines multiple models for better results. McMillan explained that different models are better suited to different tasks and run better on different kinds of hardware. For example, he noted, Claude is currently best at coding, TabPFN at interpreting tabular data, Groq at fast inference, etc. Sourcetable’s AI knows model specifications and strengths, so i’s able to understand what a user is trying to do and find the best tool for it.
While accessing public models can sometimes come with a per-prompt cost, McMillan said the company has established relationships with many service providers to ensure high rate limits and the ability to handle a large number of requests. He added that, right now, Sourcetable use a combination of manual and automated controls to prevent abuse of the system that could conceivably create large fees, though he believes the long-term cost curve indicates that AI will essentially become free, with the price of software being more aligned with value than cost of goods sold.
Prior to this release, Sourcetable did offer an AI copilot similar to many in the market that was more for formula assistance, charting and answering questions, according to McMillan. This was initially included as a SQL assistant to retrieve database data to help users who didn’t know how to write SQL, and this is how the company learned that users really wanted to use the AI for their regular spreadsheet workflows, leading Sourcetable to develop this current solution.
“Ironically, solving the database retrieval problems forced us to build our own Chain of Thought equivalent before OpenAI released theirs publicly,” said McMillan. “That taught us how to leverage processes like CoT for multistep processes and automation, and this gave us a big head start once we shifted gears toward full spreadsheet automation via AI. Today’s autopilot moves us from answering questions to thinking and agency. It’s a big leap forward.”
Sourcetable offers both a free tier and a pro tier, which costs $20 a month. All Sourcetable users get the first two weeks free on the Pro tier and can continue using the system on a rate-limited free tier. All the regular spreadsheet and charting features are free and unrestricted. McMillan added that Pro users are Sourcetable’s revenue source. Free tier users generate no revenue, he said, “although happy users spread the word, which is the best form of marketing.”
Financial advisors and clients seeking to boost the tax savings available through loss harvesting may consider an increasingly popular leveraging strategy known as the “long-short” method.
The combination of “long” investments on a stock’s positive outlook with “short” ones based on equity declines, plus margin loans that add debt leverage to the vehicle, may turn off some advisors with risk-averse clients who don’t have a lot of capital gains that need offsetting. But tax-aware long-short investing is drawing clients seeking to maximize returns through active management on a lengthy timeline with lower payments to Uncle Sam.
At their root, tax-aware long-short vehicles present “an opportunity to go overweight certain factors and go underweight certain factors and find alpha between the two,” said Brent Sullivan, a consultant on taxable investing product distribution to sub-advisory and ETF firms who writes the Tax Alpha Insider blog. The accompanying tax savings stem from loss harvesting that “oftentimes will exceed a dollar contributed” or could even reach 200% to 400% of the principal, he noted. Continual rebalancing pushes up the losses past the level available from many direct indexing strategies in a process Sullivan compares to a “perpetual ball machine.”
“The loss harvesting paradigm here is just totally different than a direct indexing long-only,” Sullivan said. “As the market goes up, you can continue shorting. Those shorts generate harvestable losses.”
Much like his research documenting the continual rise in Section 351 conversions to ETFs, Sullivan is keeping close watch on tax-aware long-short vehicles, which have already surpassed his prediction of attracting $30 billion in assets under management by the end of the year. AQR Capital Management, a pioneer in tax-aware long-short strategies, is leading the way with $21.7 billion, but other managers such as Invesco, BlackRock and Quantinno have pushed the total above at least $35 billion, Sullivan noted in a newsletter last month.
“Today, advisers recognize that tax is a practice differentiator and a source of recurring client value,” Sullivan wrote. “They may be torn between low-cost, passive index ETFs and direct indexing, but that debate fades into the background once they learn of tax-aware long/short strategies.”
On the other hand, AQR itself is seeking to “help parse the jargon of this rapidly growing but sometimes confusing area” amid some “blurring of terminology, strategy design and investment objectives,” the asset management firm said in a blog post earlier this year. The company pushed back on the idea that the strategies are “only for billionaires” or simply trying to achieve benchmark returns, along with the notion that they are a form of “supercharged direct indexing.” While their tax benefits “are larger and last longer” than those of direct indexing, the two strategies come from “diametrically opposite starting points (active management for the former versus passive indexing for the latter),” the post said.
“Tax-aware long-short factor strategies realize higher tax benefits than direct indexing not because they try harder, but because they (1) trade quite a bit due to changes in pretax alpha, (2) hold large positions relative to invested capital due to leverage, and (3) can slow unnecessary gain recognition without significantly impacting pretax alpha, thanks to relatively long holding periods and highly diversified portfolios,” the company wrote. “The core strength of tax-aware long-short strategies lies in their ability to align pretax performance with the needs of tax-sensitive investors.”
Those characteristics may eventually pose tax problems with a client’s estate plans, Sulllivan noted. Estates face an obligation to settle any debts.
“The strategy is effectively over,” he told FP. “You will realize a ton of capital gains if you suddenly, without planning, close the long and short positions.”
Advisors and their clients could take steps to wind down the leverage “years and years in advance” with as low tax exposure as possible, he said. Or they could set up an intentionally defective grantor trust or another entity instructing the trustee to manage the strategy based on a “prudent investor standard” and a long-term plan for the estate and its heirs, Sullivan said.
Since “you do not want to be auto-liquididated” upon the benefactor’s death, some of the “the brightest minds out there are thinking about trust structures” to hold the tax-aware long-short strategies, he said.
“That can be a real tax drag for any assets passing to beneficiaries,” Sullivan said. “What you do is, make sure that the trust is properly structured to continue holding margin and short positions. You’re essentially transferring the entire balance sheet of the strategy.”
The House tax committee is seeking to increase the state and local deduction and make official several of President Donald Trump’s campaign tax pledges in a multitrillion-dollar package that will serve as Republicans’ signature legislative effort.
The House Ways and Means Committee release of the tax measures, ahead of planned debate on the panel Tuesday, is a sign the Republican-controlled chamber is moving toward a floor vote this month on the legislation. The bill aims to cut taxes by more than $4 trillion and reduce spending by at least $1.5 trillion over a decade.
The proposal doesn’t include a tax hike on the wealthiest Americans, after weeks of debate among Republicans about whether to raise levies on millionaires. The bill would permanently extend the 37% top rate for individuals that was set in Trump’s 2017 tax law. That’s despite Trump telling Speaker Mike Johnson as recently as last week that he wanted a 39.6% rate for individuals making more than $2.5 million.
The package — which Trump has dubbed his “one big, beautiful bill” is the centerpiece of his legislative agenda. It renews many of his first-term tax cuts, set to expire at the end of the year. But narrow Republican margins in the House mean that the president needs near-unanimous support from his party to pass the bill.
The bill would raise the nation’s borrowing limit by $4 trillion. This is smaller than the Senate’s preferred $5 trillion level. Lawmakers are hoping to push any additional votes on raising the debt ceiling until after the 2026 midterms.
The draft language eliminates income taxes on tips and overtime pay through 2028. House Ways and Means Committee Chairman Jason Smith had vowed to follow through on Trump’s campaign pledges to end those levies.
Trump had also campaigned on ending taxes on Social Security benefits, but that cannot be done in the special budget process that Congress is using to advance the tax package. Instead, the bill provides a $4,000 bonus for seniors on top of the regular standard deduction.
One of the thorniest issues — including a contentious standoff over increasing the state and local tax deduction — is still not resolved. The draft calls for increasing the state and local tax deduction to $30,000 for both individuals and couples, up from $10,000, with income limits for single taxpayers earning $200,000 or joint filers making twice that. But some lawmakers representing high-tax areas want an even bigger tax break — as much as $124,000 for joint filers.
On the hook for tax increases: wealthy private universities, which could see an increase in the levy on endowments from 1.4% to as high as 21% on investment income.
Johnson told reporters Monday that the House is on track to pass the legislation by Memorial Day. It would then go to the Senate, where it could be subject to major revisions.
The new details come after the tax-writing committee released some initial provisions late Friday. Those included raising the maximum child tax credit to $2,500 from $2,000 and increasing the standard deduction, both retroactive to 2025 to put more money in voters’ pockets before the 2026 election.
The bill also raises the estate tax exemption to $15 million and increases the 20% deduction for closely-held businesses to 23%.
President Donald Trump’s Hollywood ambassadors joined studios, labor unions and producers in asking the White House to expand and extend tax incentives as part of an upcoming budget reconciliation bill.
A letter dated Monday asked the president to include three film and TV incentives in the budget bill being drafted by Congress. The coalition includes the Motion Picture Association, which represents Hollywood studios, as well as unions of writers, actors and other trades.
Actor Jon Voight, who was named one of three special ambassadors to Hollywood in January, is leading the effort to obtain assistance from Washington to boost US film and TV jobs. The groups signing the letter represent nearly 400,000 industry professionals. Sylvester Stallone, another Trump ambassador, also signed the letter.
The U.S. film and TV industry has struggled in recent years as entertainment companies reduced their spending and moved production overseas, where cheaper labor and more generous government subsidies make their business more profitable.
The letter doesn’t mention tariffs on foreign film production, which Trump said he would pursue in a social media post on May 4. His 100% tariff proposal, made after a visit with Voight, sent the shares of studios such as Netflix Inc. and Walt Disney Co. tumbling as investors considered the possibility of rising costs and a trade war in the entertainment business.
The specific proposals in the new letter involve reviving Section 199 of the tax code, which provided deductions for manufacturing to film and TV production, extending Section 181, which allows for accelerated deductions, and restoring Section 461, which lets businesses use past losses to reduce future taxes.