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.
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 I import investments into my 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 CSV upload.
A new window will open where you will be prompted to upload your csv file. Just follow the simple on page instructions and click Next.
Having successfully uploaded your file, you will then 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 Next, 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 Save, 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.
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.
How do I update investments I've previously imported into my 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 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.
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.
