Load Large Bloomberg Excel Data File

バージョン 1.0.0 (57.5 KB) 作成者: Michael Robbins
Load Excel data created with BDH in Excel. It can efficiently load hundreds of megabytes of Excel data.
0.0
(0)
ダウンロード: 9
更新 2023/6/7

ライセンスの表示

Load Excel data created with BDH in Excel. It can efficiently load hundreds of megabytes of Excel data.
www.QuantitativeAssetManagement.com
https://www.amazon.com/Quantitative-Asset-Management-Michael-Robbins/dp/1264258445/
>> tBBG = LoadLargeBloombergExcelDataFile('BBGHistory.xlsx',4,4,10)
tBBG =
22×2 timetable
Date AAPL US Equity IBM US Equity
___________ ______________ _____________
08-May-2023 173.5 123.4
09-May-2023 171.77 122.83
10-May-2023 173.56 123.69
11-May-2023 173.75 122.56
12-May-2023 172.81 124.52
15-May-2023 172.31 125.05
16-May-2023 172.31 125.15
17-May-2023 172.93 127.43
18-May-2023 175.29 127.88
19-May-2023 175.4 129
22-May-2023 174.44 129.25
23-May-2023 171.8 129.94
24-May-2023 172.08 127.4
25-May-2023 173.23 128.5
26-May-2023 175.67 130.66
30-May-2023 177.55 131.25
31-May-2023 177.5 130.35
01-Jun-2023 180.34 131.6
02-Jun-2023 181.2 134.23
05-Jun-2023 179.83 134.46
06-Jun-2023 179.46 134.51
07-Jun-2023 180.42 134.32

引用

Michael Robbins (2025). Load Large Bloomberg Excel Data File (https://www.mathworks.com/matlabcentral/fileexchange/130729-load-large-bloomberg-excel-data-file), MATLAB Central File Exchange. に取得済み.

MATLAB リリースの互換性
作成: R2023a
すべてのリリースと互換性あり
プラットフォームの互換性
Windows macOS Linux

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

バージョン 公開済み リリース ノート
1.0.0