Please, explain about Market Data on the ribbon menu.
From Market Data it is possible to access Yahoo! Finance and download market data. Each user is responsible for compliance with Yahoo! Finance Terms of Service. PrimaXL does not store the data in a server. PrimaXL is doing what a web-browser would do: access the site and then display the requested values on an Excel spreadsheet.
How do you enter ticker symbols in Market Data menu form?
You can directly type in the ticker symbols on the grid. Example: AAPL for Apple , MSFT for Microsoft, etc.
How do you execute the PrimaXL functions?
Almost all the features of PrimaXL are executed through the functions. These functions can be directly typed into the spreadsheet cells or be executed from the ribbon menu. The latter way is easier and preferred in most cases. Some tasks such as market data download and drawing plots can be done only from the menu (there are no functions).
Is it possible to call PrimaXL functions from VBA?
Yes. You can use the method Application.Run() to call PrimaXL functions.
How big a set of data can PrimaXL handle?
First, let us remind ourselves that Excel is probably not a proper “big data” tool. Excel spreadsheets can only handle limited amounts of data. However, to give you an idea, the time that PrimaXL takes to fit or forecast using few hundreds to thousands of data values is almost negligible. Even fitting a time series of few tens of thousands of steps can be done within seconds. Also, linear regression analysis using a million data values can be done in reasonable time. The performance is closely related with the system specification.
How can I trust the calculation results of PrimaXL?
PrimaXL went through several quality assurance tests. Also, PrimaXL’s performance was tested against other statistical programs.
What is the foundation of PrimaXL?
The functions and features of PrimaXL are based on proven concepts from statistics, econometrics, computer science, finance engineering, etc.
How much can you trust a statistical forecast?
Here, the main assumption is that during the forecast period the statistical properties of the training period remain the same. However, some unforeseeable event may happen and render the above assumption invalid. Thus, one should interpret carefully the forecast output. Also, one should consider that the forecast lies within an interval defined by probability.
