Genovo's Bulk Investment Importer has been designed to allow users to quickly and easily upload information about the investments (funds, portfolios etc) they frequently recommend to their clients into their Investment Library.
By adding an investment to the investment library you (and your users) will be able to add it to an investment strategy within a review or the Recommended Investment Strategy section with just a couple of clicks, which in turn could save you heaps of time as you’ll never need to re-key this information again.
Using the Bulk Investment Importer you can import up to 50 investments into your Investment Library at one time. Once the investments have been imported, the importer can also be used to keep the information about these existing investments regularly up-to-date, as well as import any new investments should you need to.
How do you import investments into your Investment Library?
In the first instance you will need a csv file of the investment-related data you wish to import. This could be achieved by:
- exporting the data from a separate app. (e.g FE Analytics, Morningstar Workstation etc) as a csv file;
- converting an excel file of investment data into a csv file; or
- creating the csv file from scratch.
You will find further information about the sort of things you will need to consider when preparing your csv file here.
So assuming you have your csv file ready to import, on entering your Investment Library you will need to click import investments.
You will then be taken through to a new page where you will be prompted to upload your csv file - just follow the simple on page instructions.
Having successfully uploaded your file, you will be directed to a new page where you will be prompted to map the fields in your CSV file (as shown in the drop down) to the equivalent fields in the Genovo Investment Library. You do not need to map all fields. However, you will need to select a mapping for Genovo’s Unique Identifier and Investment fields as they are mandatory.
On clicking the next arrow, you will then be taken to a summary screen where you will be prompted to confirm the selected field mappings are correct.
Assuming you’re happy to proceed you should then click import, and all of the investment records in the csv file will be uploaded and show as new investments ‘owned by you’ within your Investment Library. Please be patient if you are importing a number of investments - this may take a little time. Please don't click off the screen, you'll be returned to your Investment Library once all the investments have finished importing.
Having imported the investments into your library, you can then edit and manage them, and (assuming you’re an admin of a multi-user company plan) share them with other users within your account in the usual way.
How do you update investments you’ve previously imported into your Investment Library
Clearly information relating to a particular investment (such as its objective, charges or even its name) can change over time; and you may wish to do a mass update of the investments that you previously uploaded into your Investment Library, and maybe even add some new ones. The Genovo Bulk Investment Importer has been specifically designed to facilitate this.
By giving each investment a unique ID, you can simply upload a new csv file containing the updated information, using the same process as above, and the importer will intelligently match any investment record with the same ID and automatically update any mapped fields. It is important that the ID for a particular investment does not change otherwise a duplicate investment will be created.
For further information about unique IDs and other considerations when preparing your csv file click here.
It is important to note that only those fields that you map on any subsequent import will be updated - all other fields will remain as is. So if you have manually added any data into any other fields (e.g a table or asset allocation pie chart into the Further Investment Info field) following the original upload, this wouldn’t be overwritten.
It is also important to note that any selections e.g share / show that you’ve made for a particular investment will remain as is following an update.
Example csv file
To assist with your understanding of how to structure your csv file, included below is the contents of a sample csv file containing 2 investment records.
Row 1 ID,Investment,Objective, Risk Rating,OCF,Ex-ante,DFM Charge
Row 2 Gen Port 1,Genovo Cautious Portfolio,"The portfolio is designed for a cautious investor who is primarily concerned with capital preservation.”,Low,0.48%,0.22%,0.25%
Row 3 Gen Port 2,Genovo Balanced Portfolio,"The portfolio is designed for a medium risk investor who is looking to invest for growth.”,Medium,0.53%,0.22%,0.25%
Remember the number and names of the fields in your csv file do not need to match the fields in the Genovo Investment Library as you will have the opportunity to map the fields in your csv to their equivalent within Genovo on upload. Using the above sample csv file as an example the mappings could look like this.