Analysis of generated stock market data finding greatest percentage increase, greatest percentage decrease and greatest total volume.
Please run the "run_all" program to pull and calculate the summary tables and to format the appropriate cells.
I broke down the problem into sub programs, "summary_table", "conditionals_formatting", "summary_table_2" and created a master program, "run_all" to call and run these programs. The "clear_sheet" program clears any previous data and formatting where the tables will sit. And lastly, "clear_all" is the same as "clear_sheets" but for all worksheets.
| Ticker | Value | |
|---|---|---|
Greatest % Increase |
THB | 141.42% |
Greatest % Decrease |
RKS | -90.02% |
Greatest Total Volume |
QKN | 1,689,539,560,106 |
| Ticker | Value | |
|---|---|---|
Greatest % Increase |
RYU | 190.03% |
Greatest % Decrease |
RKS | -91.60% |
Greatest Total Volume |
ZQD | 4,373,008,528,422 |
| Ticker | Value | |
|---|---|---|
Greatest % Increase |
YDI | 188.76% |
Greatest % Decrease |
VNG | -89.05% |
Greatest Total Volume |
QKN | 3,452,956,568,861 |