Non listed stocks and how to handle the quotes?

Uffe

I have some non listed stocks, that get a new official quoted price each year after the general meeting has been held in the company. So I will have to maintain the quotes manually some how.

Should I update psConfig.txt in below way?

# GeneratedQuotes: to create static price quotes. Format: Symbol,MinDate,MaxDate,Price

DANFOSS,2002-05-01,,752
DANFOSS,2003-05-01,,931
DANFOSS,2004-04-30,,1307
DANFOSS,2005-05-01,,1438
DANFOSS,2006-05-01,,1791
DANFOSS,2007-05-01,,2273
DANFOSS,2008-05-01,,2127
DANFOSS,2009-05-01,,830
DANFOSS,2010-05-01,,1077
DANFOSS,2011-05-16,,3434
DANFOSS,2012-05-01,,3198
DANFOSS,2013-05-01,,3460
DANFOSS,2014-05-01,,4116
DANFOSS,2015-05-01,,4267
DANFOSS,2016-04-29,,4904
DANFOSS,2017-04-28,,6100


Or is there a better way to keep track of the quotes?

buddyb

Uffe,

For what you want to do, there is no need to modify the psConfig.txt file.

To create and use a manual quote file try the following:

1. Create a folder called "Manual Quotes" inside the C:\PortfolioSlicer\Quotes folder. This is a bookkeeping thing, it allows you to easily track your manual quote files. The script files will find this data.
2. Inside the new "Manual Quotes" folder, you will make a "Text" file that lists your stock prices. In your case, the filename would be: "_DANFOSS_.txt " (without the "'s).
3. The data you will be adding inside this text file will have the following format: YYYY-MM-DD, the stock price, your Stock name. (in your case: 2017-04-28,28,6100,DANFOSS. One line per daily price entry. As a minimum, PortfolioSlicer needs at least 1 price each month to do it's calculations.
4. Over in the main PortfolioSlicer spreadsheet, Within the "srcSymbol" tab, enter your stock symbol "DANFOSS" within the "Symbol" table.
5. Within the "srcTrans" tab, all buys/sells etc will use the SymbolName "DANFOSS".
6. Everything should be linked up and work as it normally does when you refresh your File.

(ps: For data entry, I like using an Excel style "CSV (MS-DOS)" type spreadsheet. When it is time for an update, I copy the spreadsheet into the "Manual Quotes" folder and renaming the file extension from *.CSV to *.txt)

++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Vidas has nicely described external manual files in the following post:
http://portfolioslicer.com/scripts/quotes-data.html

buddyb

Note: When you enter your stock price, use the "," or "." separator format that your PortfolioSlicer files is configured to be.

Uffe

Thanks it works nicely.