I have a query which retrieves stock data by URL to www.morningstar.com. I also have a list of stock tickers and Morningstar IDs. What I want to do is to have PQ iterate through the list of stock tickers and refresh the query by updating the URL with the ID and to append the results of each query to a table that will hold the results of each query. I have everything sorted out except for the iteration part where PQ will loop through the list of stock tickers and pass the ID to the Source (URL string) before the query is refreshed and results appended to the cumulative table. The idea is that the list of stocks will be dynamic as tickers will be added or removed. I can of course just have a set of "static" queries that I modify each time I want to add or remove a ticker, but that doesn't appeal to me as a smart solution.
Would be grateful if anyone has some code or resources that could point me in the right direction. Have tried "everything" including asking ChatGPT but have not been able to find something that works. I guess I should add that I am not a very sophisticated PQ user although I am using PQ a lot for various data management tasks.
Would be grateful if anyone has some code or resources that could point me in the right direction. Have tried "everything" including asking ChatGPT but have not been able to find something that works. I guess I should add that I am not a very sophisticated PQ user although I am using PQ a lot for various data management tasks.