export investing portfolio view data
Options
bill21
Member ✭✭✭
is there any way to export the columns in investing portfolio view to csv or excel-compatible format file? I'm particularly interested in the "dividend yield", "shares", and "quote/price" columns (to be able to estimate annual dividend/interest income). I have quicken deluxe for windows. thank you.
Tagged:
0
Best Answers
-
Yes! While viewing the Portfolio view you want to export, press CTRL P on your keyboard, select print to file, and choose either tab-delimited or 123 compatible (CSV). This will create a text or CSV file that you can import into Excel.
Quicken user since Q1999. Currently using QW2017.
Questions? Check out the Quicken Windows FAQ list7 -
Actually the selection you want is the confusingly named PRN (123 compatible). Then if you give the file a CSV extension you can open the it directly in Excel, without going through the text file import wizard.QWin Premier subscription6
Answers
-
Yes! While viewing the Portfolio view you want to export, press CTRL P on your keyboard, select print to file, and choose either tab-delimited or 123 compatible (CSV). This will create a text or CSV file that you can import into Excel.
Quicken user since Q1999. Currently using QW2017.
Questions? Check out the Quicken Windows FAQ list7 -
Actually the selection you want is the confusingly named PRN (123 compatible). Then if you give the file a CSV extension you can open the it directly in Excel, without going through the text file import wizard.QWin Premier subscription6
-
Anyone here even remember Lotus 1-2-3? LOL!0
-
And before that there was VisiCalc!QWin Premier subscription2
-
Thank you , all, very helpful!1
This discussion has been closed.