Investments without stock symbols

woody21

Hi All, does anyone know how to manage holdings in the workbook that do not have associated stock symbols for quotes? For example, bonds, private investments etc.? Is there a way to enter and update these manually?

VidasMatelis

If you have investments with fixed price, example (GIC), then you can use Generated quotes - this will create one quote per month with the same price. More info on this page: http://www.portfolioslicer.com/scripts/config-file.html in "GeneratedQuotes" area:

GeneratedQuotes - This parameter is used by script “AppendGeneratedQuotes.ps1”. This parameter value could have multiple lines with each line with following data: “Symbol,MinDate,MaxDate,Price”. Here “Symbol” usually will be your own created symbol (Example: VidasGIC20170101”) and the same value should be in table “Symbol”. Value MinDate (format YYYY-MM-DD) should be start date from when quotes for this symbol will be created. If value is not specified, then parameter “MinDate” value from this file is used. Value MaxDate (format YYYY-MM-DD) is value that shows up to when quotes for this symbol should be created. If MaxDate not specified, then we will use current date. Value “Price” should be price for your investment.

If you want to track investments that change in price, you can always manually maintain price list of symbol quotes. More info on how quotes are stored localy is here: http://www.portfolioslicer.com/scripts/quotes-data.html
So you would create one file for each symbol in Quotes\Manual subfolder and store there at least one quote per month.

woody21

Thank you for the guidance / information