Fundamental and Technical analysis, daily stock performance reports, market indexes, and securities lending.. Explosion of portfolio holdings down to the last level, enabling evaluation of indirect holdings linked to the fund. Access the most reliable and complete database for equities, fixed income and the fund industry to support all levels and areas of your business. Access the most reliable and complete historical database of exchange-listed companies and the fund industry.
This highest quality data will transform your papers and help you reach international prestige. A powerful Data Mining platform, being fed continuously with data that can be utilized to generate insights, perform complex simulations, build reports, compare assets, test out hypotheses and make informed decisions. Retrieve the robust data you need, create charts and reports by leveraging the Excel native tools.
Download the Economatica Excel Add-in and run the install program. Click Sign up from top menu to request your login password. Check your inbox in a few minutes for an email confirmation. Generate customized templates filtered by numerous quantitative or qualitative metrics designed to meet custom-defined criteria. Also, screening for Beta Neutral or Cash Neutral pairs is an option. Easily build comparables for peer securities. Access the data without copying between applications, manage fund reports, market multiples, and create customized templates with great ease and flexibility.
Using the Data Feed API, you have instant access to thousands of data points from financial markets, backed by the credibility of a firm with 30 years of experience. Portuguese Spanish English.
These changes are caused by the fact that the portfolio holdings have different valuations over time. Y : Rebalance. The composition will remain unchanged despite the fact that the portfolio holdings have different valuations over time because the system will create a scenario equivalent to executing daily buy and sale operations necessary to keep the initial weights unchanged.
In the case of the Percentage Portfolio there is a limit to the number of cells in the matrix, that is, there is a limit to the combination of the number of assets rows and the number of dates on which the composition was informed columns. It is not possible to set a fixed limit size because the limit depends on the content of each cell.
Example : If each cell is filled with two decimal places ex For reference only, the maximum size for a Percentage Portfolio with cells filled to 2 decimal places Ex This corresponds, for example, to a portfolio with 45 assets lines and composition informed on dates columns. A price series will be created for this benchmark so that your returns are equal to the returns of the base security but amplified by a factor chosen by the user.
If the user chooses a factor of 6, the benchmark variation will be Example of the calculations involved in the creation of a benchmark that multiplies by a factor: Consider a day when the change in the base security has been 0. If the user chooses a factor equal to , the variation of the benchmark will be 0. The start date of the benchmark series will coincide with the start date of the series of the base security.
Enter in this field the code as used in the Economatica system to be used as the base security for the benchmark. In this field you must enter the value of the factor. Ex: 5, As we know, Excel lets you type a function in the cell itself without opening the function edit screen. To do so, you must follow the syntax below and include the fields in the same order as they are shown in the function edit screen. The examples above present the case where all fields are used. Most cases however will use only a few fields.
Even if one or more fields are not used, it's necessary to maintain the proper syntax order as indicated above. Therefore, you must leave a blank space in the fields not used. Notice in the examples below how two consecutive commas with no content in between are found in the place of the unused fields. The fields must be separated by the character that your Windows uses as "List Separator".
If you do not know which character your Windows uses as the list separator, you can use the following rule as a guide this rule is not valid if you have changed your Windows default settings : Fields must be separated with a comma when Excel uses the dot as the decimal separator.
While the fields must be separated by semicolons when Excel uses the comma as the decimal separator. In the following examples the fields are separated by commas:.
In this case only the first two fields will be used. In the case of the closing price the attribute's period field is not used, so an empty space must be left in the reserved position for this field this is the empty space that is between two commas. Show inflation-adjusted data. Omit the header. In this example the fields "range start date", "interval", "multiplier" and "show dates" will not be filled so you must leave empty spaces in the reserved positions for each of these fields.
Initially you should open the Economatica system, that is, access the proprietary interface of the Economatica system. Please contact our support if you do not know how to operate the proprietary interface of the Economatica system. Once in the Economatica system you should open the Screening window or the Matrixx window and create columns containing the data you want to have in Excel. Then you have to highlight the desired data, right click on the highlighted area and choose the option "Export to Excel add in".
When doing this you will be pasting in Excel not the data itself but the functions that will allow your Excel to communicate with the Economatica servers and fill the cells with the desired data.
After doing this operation and saving your Excel spreadsheet you will no longer need to use the proprietary interface of the Economatica system. In these cases you will receive the message: "The server returned an error: Proxy Authentication" the exact text message may vary depending upon your environment. Option 2 Enter the configuration settings of the proxy into a specific window found in the Economatica Excel Add-in.
The configuration window will appear on the right-side of the screen. Complete the fields indicated in the image below. Ask your IT for the specific settings that are required. The displaying of this icon does not necessarily indicate a problem. See below the description of its meaning. Economatica's server is constantly being updated with new data.
0コメント