We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

.NET cells -> Support STOCKHISTORY

We have a client that is heavily using the STOCKHISTORY function. When we try to re-calculate his Excel -> we are receiving #Name result.
Is this function support/planned to be supported?
Thanks

@eyalmolad,

The STOCKHISTORY function may not be supported by Aspose.Cells’ formula calculation engine. Could you please share a sample Excel file containing the underlying formula in tact, we will evaluate and may log appropriate ticket(s) for it into our database.

Here we go.
stocks.zip (20.8 KB)

@eyalmolad,

Thanks for the sample file.

I have logged a ticket with an id “CELLSNET-51911” for your issue/requirements. We will evaluate the STOCKHISTORY function in details. Once we figure it out, we will let you know.

@eyalmolad,

We found the calculation of this function requires different protocols and permissions to connect to different external data sources, which is beyond the constraints of our components about security. And such kind of process also causes user concerns about security. So we are afraid we cannot support it directly.

However, we plan to support users to set/refresh/calculate those formulas which use this function with their own custom engine (implementation of AbstractCalculationEngine). We will provide the ultimate values of those parameters of this function so users can fetch data accordingly.

Please let us know whether this solution can fit your requirements? If yes we may provide some new APIs and share some example code of this solution for you later.