Hi Experts,
I have a table linked with data type "stocks", is there any way that data can refresh automatically in every minute ?
Please help, if possible, please share VBA code.
Regards,
Zubair
I have a table linked with data type "stocks", is there any way that data can refresh automatically in every minute ?
Please help, if possible, please share VBA code.
| Cricket.xlsx | ||||||
|---|---|---|---|---|---|---|
| B | C | D | E | |||
| 1 | Stock price | |||||
| 2 | Shares | Price | 52 week high | 52 week low | ||
| 3 | BP P.L.C. (XLON:BP.) | $ 478.45 | 571 | 441 | ||
| 4 | SHELL PLC (XLON:SHEL) | $ 2,487.50 | 2,801 | 2,149 | ||
| 5 | ||||||
Sheet2 | ||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| C3:C4 | C3 | =[@Shares].Price |
| D3:D4 | D3 | =[@Shares].[52 week high] |
| E3:E4 | E3 | =[@Shares].[52 week low] |
Regards,
Zubair
