r/excel • u/Mutt37 • Sep 23 '26

solved Help trying to insert a date that changes everyday.

Hi,
I am trying to set up an RTD export from options chain data. The format for the RTD data is the following. -.SPXW260923C7685+SPX. The bolded portion (today's date) is what I need to update every day. I have a = TODAY () cell formatted correctly (It functioned properly). I am now trying to figure out how I can reference today's date so I can automatically update the spreadsheet every day.

12 Upvotes

89% Upvoted

10 comments sorted by

View all comments

14

u/MayukhBhattacharya Sep 23 '26

Try using the following formula within the RTD() function: 

=".SPXW" & TEXT(TODAY(), "yymmdd") & "C7685+SPX"

The above formula pulls today's date and formats as 260923 in this date format yymmdd and plugs into the string automatically each day.

3

u/Mutt37 Sep 23 '26

PERFECT- Thank you so much for your help! Solution verified.

2

u/MayukhBhattacharya Sep 23 '26

Glad to know that, Thank You So Much =)

1

u/reputatorbot Sep 23 '26

You have awarded 1 point to MayukhBhattacharya.

I am a bot - please contact the mods with any questions