Obtaining the Market-Value-Shock report from Raymond-James eFolio

Is your bank a customer of Raymond-James in Memphis? Their eFolio system generates a report called “Market Value Shock” which we can use as the investment detail download into A/L BENCHMARKS. To obtain the report here are the steps to follow:

2) Go to report downloads Select your portfolio and go to reportfolio-Downloads under the portfolios tab. Here’s a screen shot:

(click image to enlarge)

3) Run the report Select Analytics pre-formatted reports on the left and the “Market Value Shock” from the right. Click on “Run Report”. Here’s a screen shot:

(click image to enlarge)

4) Download the report to your computer Step 3 (above) will populate the report on the page; download it to excel using the “download the data to a spreadsheet link”. Here’s a screenshot:

(click image to enlarge)

5) Upload the spreadsheet file to Olson Research Send the file to us using your secure login, the same way you send to us your Service Kit, Loan data, and any other quarterly information. The investment file would typically be uploaded in “Step 4”. You don’t have to adhere to a specific order. At this point you may not have your Call Report file ready yet. That’s ok you can return to Steps 1 - 3 at a later: