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

 

[GAURAV SEMWAL]

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.

View attachment 76860

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.

SIR THANK YOU FOR THE HELP IT IS WORKING ,AND CAN I ASK ANOTHER QUERY HERE.

 

[smozgur]

SIR THANK YOU FOR THE HELP IT IS WORKING ,AND CAN I ASK ANOTHER QUERY HERE.

You're welcome.

Please start another thread for your new question if this one is solved.

 

[smozgur]

@GAURAV SEMWAL: I changed the marked solution post with the actual answer post as it will help future readers. That would be great if you could also mark the post that answered the question in your future questions. No further action is required in this thread.

Also, please let me remind you that using all caps in posts is usually a not good way to communicate since it is hard to read a post consisting of all capital letters. Besides, it sounds like you are shouting. So, I suggest typing your posts as in your initial posts in this thread.

Welcome to the MrExcel Message Board!

 

[GAURAV SEMWAL]

@GAURAV SEMWAL: I changed the marked solution post with the actual answer post as it will help future readers. That would be great if you could also mark the post that answered the question in your future questions. No further action is required in this thread.

Also, please let me remind you that using all caps in posts is usually a not good way to communicate since it is hard to read a post consisting of all capital letters. Besides, it sounds like you are shouting. So, I suggest typing your posts as in your initial posts in this thread.

Welcome to the MrExcel Message Board!

 

[GAURAV SEMWAL]

thank you very much sir for correcting my mistakes actually i have pity on this platform and i don't have any idea how to use it just by searching google i have come to this platform if i have written something wrong please do me sorry for that.
And I have also put a new thread but I have put that too in caps on, how to correct it, I do not have any idea about that.

 

[smozgur]

thank you very much sir for correcting my mistakes actually i have pity on this platform and i don't have any idea how to use it just by searching google i have come to this platform if i have written something wrong please do me sorry for that.
And I have also put a new thread but I have put that too in caps on, how to correct it, I do not have any idea about that.

Nothing to be sorry about. My explanation is purely for helping. So you might get faster responses by following some simple rules. Otherwise, it might take some time to understand why your questions are not replied to at all. In fact, you might want to read the forum help section (especially the first three articles) which is a good starting point for this platform.