![]() The dynamic web query file for a simple google search would look like this. Notice that q is the name of the parameter, and the action tells you what the URL should be. If you dont know what parameters are for, just browse the web for a while and pay attention to what shows up in the address bar of your browser. Its not always going to be better, and its not always going to work, but its worth a try, especially since a simple web query could boost your productivity. What I mean is the ability to change the parameters of the web query, such as typing in a new stock symbol into a cell and having the table update automatically. You can then use Excel formulas (like A1B2) to work directly with the data youve downloaded.Īnd you dont have to know anything about perl, cgi, php, javascript, etc.įor more information about using web queries to download Stock Quotes into Excel, take a look at the Excel Stock Quotes Template. I would like it to automatically select each order number and go down the list.
0 Comments
Leave a Reply. |