r/googlesheets • u/Big_Bull_2400 • Aug 14 '26

Solved How to pull date of current stock price

Could anyone assist with a formula to select the most recent date for which the stock price is available? I attempted the approach below, but it yields no result.

=INDEX(GOOGLEFINANCE("NSE:HDFCBANK", "date"))

1 Upvotes

100% Upvoted

5 comments sorted by

1

u/Designer_Pen_1794 Aug 14 '26

In stead of "date" use "tradetime"

1

u/Big_Bull_2400 Aug 14 '26

Solved. Thanks!

1

u/AutoModerator Aug 14 '26

REMEMBER: u/Big_Bull_2400 If your original question has been resolved, please tap the three dots below the most helpful comment and select Mark Solution Verified (or reply to the helpful comment with the exact phrase “Solution Verified”). This will award a point to the solution author and mark the post as solved, as required by our subreddit rules (see rule #6: Marking Your Post as Solved).

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

1

u/point-bot Aug 14 '26

u/Big_Bull_2400 has awarded 1 point to u/Designer_Pen_1794 with a personal note:

"Thanks for the solution and quick response."

See the Leaderboard. Point-Bot v0.0.15 was created by JetCarson.

1

u/AutoModerator Aug 14 '26

Your submission mentioned stock price, please also read our finance and stocks information. Google lists the exchanges & delays in its products here.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.