D
dynamicsoul
Hi....
im pretty much starting out with macro's and vba.......
I am trying to collect some stock data via a query and create a macro
to loop the following process every minute so I can plot a chart from
it within excel.............
What I need to do is this...........
create a macro that will repeat this following process every minute
until I close the excel folder:
I have a web query which retrieves data on a table from a web page,
refresh every minute.
The macro has to read the stock prices in one particular column (30
prices)after every refresh, determine whether the colour of the price
is green(+) or red(-).
The macro then needs to calculate how many values are green, and how
many are red. (e.g 25 green stocks, 5 red stocks)
Then it needs to place the amounts of each into two columns (B+C) in
sheet 2 of the workbook.
It then has to repeat this process each time the web query has
refreshed the data, but this time placing the new amounts of green and
red in the next 2 blank cells in columns B + C on sheet2..........
So I get a list of amounts for every minute so the chart can be plotted
against a time frame.....................
can I ask another question while Im here........???????
Can data be retrieved with a web query from a live streaming java
table............?
im pretty much starting out with macro's and vba.......
I am trying to collect some stock data via a query and create a macro
to loop the following process every minute so I can plot a chart from
it within excel.............
What I need to do is this...........
create a macro that will repeat this following process every minute
until I close the excel folder:
I have a web query which retrieves data on a table from a web page,
refresh every minute.
The macro has to read the stock prices in one particular column (30
prices)after every refresh, determine whether the colour of the price
is green(+) or red(-).
The macro then needs to calculate how many values are green, and how
many are red. (e.g 25 green stocks, 5 red stocks)
Then it needs to place the amounts of each into two columns (B+C) in
sheet 2 of the workbook.
It then has to repeat this process each time the web query has
refreshed the data, but this time placing the new amounts of green and
red in the next 2 blank cells in columns B + C on sheet2..........
So I get a list of amounts for every minute so the chart can be plotted
against a time frame.....................
can I ask another question while Im here........???????
Can data be retrieved with a web query from a live streaming java
table............?