Forum Discussion
Change All Date Web Queries In Work At Once Updating Cryptocurrency
I have six sheets with a history of the past 3 months of prices on 6 cryprocurrencies. I pulled the data for each sheet using the Power Query on Coinmartketcap.com Example: https://coinmarketcap.com...
How about using a parameter (type text) for start date ("20171102") and end date ("20180202") and use these parameters in the source step of your queries? Replace the hard coded dates in the URL with your parameters.
Hope this is what you were looking for.
Dominik.