How to Paste Returns from Excel to New Asset?
Submitted by doakley on Mon, 03/28/2016 - 13:35
The directions have a "link" to get the asset return data from another source but it doesn't work. So, I want to copy and paste from excel the yearly returns of new assets so I don't have to manually enter them. I can't find in the directions how to do this. Can you tell me, please?
Subscribe to RSS feed
Comments
dan royer
Mon, 03/28/2016 - 15:17
Permalink
I'm sorry, I can't see or
I'm sorry, I can't see or recall a "link" to import return history to create a new monte carlo asset. As far as I know, you have to manually enter each year.
doakley
Mon, 03/28/2016 - 16:20
Permalink
From page 34. "Thus, we
From page 34. "Thus, we have a spreadsheet you can use [linked here] to get the data based on readily available numbers from Morningstar, Yahoo, or your fund prospectus"
dan royer
Mon, 03/28/2016 - 21:33
Permalink
Ah, sorry. That needs to be
Ah, sorry. That needs to be removed. We have changed the way MC assets are created. You do that in the user interface of the program now. So you'll need to get the history of returns from finance.yahoo.com or morningstar.com or your fund source and manually enter the rate of return for each year. Sorry for the confusion. I'll get that manual updated.