文件名称:库存分析:VBA模块工作
文件大小:1.38MB
文件格式:ZIP
更新时间:2024-03-04 17:56:56
VBScript
使用VBA进行库存分析 1.概述 Steve wanted to expand the capabilities of the spread sheet to analyze the entire data set. To achieve this, VBA code was used and a script to loop through the entire data sets for 2017 and 2018. Only 12 ticker symbols were provided in the data sets and the closing prices were used to determine the returns. 2.结果 Overall, for these 12 stocks, 2017 saw a better performance compared
【文件预览】:
stock-analysis-main
----Code_example.PNG(94KB)
----VBA_Challenge.xlsm(326KB)
----VBA_Challenge_2017.PNG(43KB)
----VBA_Challenge_2018.PNG(44KB)
----Timing_2017.PNG(6KB)
----README.md(2KB)
----green_stocks_edited.xlsm(326KB)
----Timing_2018.PNG(7KB)
----green_stocks.xlsm(308KB)
----VBA_Challenge.vbs(3KB)
----green_stocks.xlsx(301KB)