Thanks for looking --
I'm trying to create an excel worksheet that will query a website that requires login credentials, but the kicker and what I'm having the most trouble with, is actually creating a log/database of the data retrieved by excel.
Goal: To see the time trends by creating a chart that has the following from each query retrieved: Day of query, Time of Query, and various bits of information (such as current stock price).
Actions tried: I tried to record a macro the basic record way and to query the website, paste the info, and in my chart below to vlookup the fields I want. I also used =today and =now to get date/time. The issue was the data is obviously going to be pasted over each time so I wouldn't be able to see the trends over time.
Another issue is that sometimes certain criteria are not pulled (it's not out of error but just isn't in available on the website pulled) -- to combat this, I thought to use a vlookup (looking for the headers of the chart) for the fields that I want in the chart.
ANY help will be valued -- even if it's a point in right thought process or function to use.
Thanks!
I'm trying to create an excel worksheet that will query a website that requires login credentials, but the kicker and what I'm having the most trouble with, is actually creating a log/database of the data retrieved by excel.
Goal: To see the time trends by creating a chart that has the following from each query retrieved: Day of query, Time of Query, and various bits of information (such as current stock price).
Actions tried: I tried to record a macro the basic record way and to query the website, paste the info, and in my chart below to vlookup the fields I want. I also used =today and =now to get date/time. The issue was the data is obviously going to be pasted over each time so I wouldn't be able to see the trends over time.
Another issue is that sometimes certain criteria are not pulled (it's not out of error but just isn't in available on the website pulled) -- to combat this, I thought to use a vlookup (looking for the headers of the chart) for the fields that I want in the chart.
ANY help will be valued -- even if it's a point in right thought process or function to use.
Thanks!
