Forum Discussion
Liton
Apr 29, 2025Copper Contributor
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
Sort By
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