power query code for fetching the data.

[GAURAV SEMWAL]

hello anyone please help me to fetch data from below given link after just selecting or changing the date.

https://archives.nseindia.com/content/historical/DERIVATIVES/2022/OCT/fo21OCT2022bhav.csv.zip

 

[Automatrix]

What exactly do you mean by "just selecting or changing the date"?

 

[GAURAV SEMWAL]

Sir, by changing the date from the pop up that data is to be come in excel TAB.

 

[Automatrix]

Where is the selected date stored?

 

[GAURAV SEMWAL]

Where is the selected date stored?

sir this is the code for getting the date.

 

[Automatrix]

Power Query will not be able to access the chosen date unless it is stored in a cell in your sheet.

 

[GAURAV SEMWAL]

Power Query will not be able to access the chosen date unless it is stored in a cell in your sheet.

iiii

sir this is different file i am getting by this process
this is a code for link
and second code is for getting date.

 

[GAURAV SEMWAL]

I AM GETTING THIS ERROR BY USING THIS PROCESS.

 

[Automatrix]

I'm afraid I can't understand your process well enough to be of much help. Maybe replace the "& Date()" section in the Source with a hardcoded value to see if that changes anything.

 

[smozgur]

It is a syntax error in the code and is also indicated in the error message. To fix the error you reported above, remove the unnecessary closing parenthesis after the .csv" in the first line.

I don't see any custom Date() function in your code, so it might still fail but this syntax error must be fixed first in order to get to the second step.