Wolfram Cloud Document

DownLoad Data - Excels into TimeSeries:

I modified the excel spreadsheet by adding one column. Now the spreadsheet consists of 3 columns. Column1 = Date, Column2 = Close, Column3 = Delta%. Both Column2 data and the newly added Column3 Data are Real64. I would like to perform calculations such as: Mean, StandardDeviation, Histogram, NormalDistribution, ect. to both Column2 and Column3.

In[]:=

dataFINSX=First@Import["C:\\Users\\masandlin\\Documents\\Financial\\FundsWork\\FGINX_Data20260718.xlsx","TimeSeries"][[1]]

Out[]=



Tue 18 Jul 2023 00:00:00GMT-4

,TabularRow

Column count: 2

Columns: CloseReal64,Delta%Real64



In[]:=

datasetFINSX=Association["TimesStamp"->#[[1]],#[[2]]]&/@dataFINSX["DatePath"]//Dataset;

Part

:Part specification DatePath〚1〛 is longer than depth of object.

Part

:Part specification DatePath〚2〛 is longer than depth of object.