库存分析:VBA模块工作

时间:2024-03-04 17:56:56
【文件属性】:

文件名称:库存分析: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)

网友评论