Forum Discussion

Liton's avatar
Liton
Copper Contributor
Apr 29, 2025

STOCKHISTORY

The issue regarding STOCKHISTORY function in MS Excel 365. Till yesterday night, it was returning weekly data, not today.

It is only returning STOCK Data till 25-4-25.

My function is like ' = STOCKHISTORY(A3, F1-1, F1-1, 1, 0, 2 )' where A3 = Stock Data, F1 = Today. It is returnnig today Op, CL through function A3.Open and A3.Price. It is also working for monthly.

Got good support from MS for technical repair (Quick) but that didn't yield any result.

It is also worth mentioning that, this Stock data fetching thru STOCKHISTORY function from possibly REFINITIV system, is always erratic and non-dependable for business purpose. 

Request for urgent please.

 

S/W: MS Office 365 Subscription

H/W: Dell Inspiron 5640, Win 11 Home.

 

 

Thanks & Regards

Liton Nandy

1 Reply

  • It may related to the data source, any luck to try with different data ranges or force a refresh, please also check on regional settings

Resources

OSZAR »