Help importing historical stock prices

Mon Jun 20 19:51:13 EDT 2016

Thanks David.
I did "deselect" the investment accounts - but then, of course, the balance sheet doesn't balance.
So - I have already exported one balance sheet to Excel and I will go that route.
At least I know I haven't overlooked a simpler solution.
Again, thanks for your time and advice.
Jim

-----Original Message-----
From: David T. [mailto:sunfish62 at yahoo.com] 
Sent: Monday, June 20, 2016 6:51 PM
To: Jim Vincent <jimvincent2 at comcast.net>
Cc: Gnucash <gnucash-user at gnucash.org>
Subject: Re: Help importing historical stock prices

Jim,

Thanks for explaining your case a little more clearly.

If I understand correctly, you have your periodic valuations already in a spreadsheet, yes? If so, then I would go with that. 

As for excluding information, you have a few options. First, you could export the report results to a spreadsheet and edit out the information you don’t want at that point. There are a number of list users who would recommend that anyhow. Second, you could exclude investment accounts from the report by clicking the Options button once you invoked the report, and click the Accounts tab, and select only the accounts you want in the box there. (Note that the selector tool can be finicky, and if you want to select specific accounts, you can do so by Ctrl- or Apple-Clicking the accounts you want).

Cheers,
David

> On Jun 20, 2016, at 1:34 PM, Jim Vincent <jimvincent2 at comcast.net> wrote:
> 
> David -
> Thanks for the prompt reply.
> I am trying to get accurate historical data for the last six years for some reports required by the courts in relationship to a guardianship account. I had recorded data in Quicken - but I became dissatisfied with it - so I a m trying GnuCash. I have imported the data from Quicken, and cleaned it up. But, as noted below, unrealized gains and losses without corresponding stock market values aren't accurate.
> Maybe I can figure out a way to exclude unrealized gains and losses - and exclude the related invest accounts (which I could then report on separately). I have market values in Quicken and in a spreadsheet.
> Any suggestions will be appreciated.
> Thanks again 
> Jim Vincent
> 
> -----Original Message-----
> From: David T. [mailto:sunfish62 at yahoo.com] 
> Sent: Monday, June 20, 2016 11:44 AM
> To: Jim Vincent <jimvincent2 at comcast.net>
> Cc: david.carlson.417 at gmail.com; gnucash-user at gnucash.org
> Subject: Re: Help importing historical stock prices
> 
> Jim,
> 
> The short answer of course would be that you would need past valuations for the income statement to give accurate past values. 
> 
> However, I personally am mostly interested in what my portfolio might be worth today, and how that compares to what I paid for it. I am not as concerned about how much it was worth six months, a year, or five years ago. The Income Statement (Balance Sheet?) also reflects that, since it defaults to give a snapshot as of the end of the accounting period. I understand that it is simple to change the date for the snapshot to another date, and thus obtain values for other dates. However, if the report were aiming to give performance over time, then it seems to me that there would be interim valuations included in the report. 
> 
> I guess I would ask you how this historical data would benefit your analysis of your holdings today?
> 
> Regardless of our own opinions about the importance of such data, the tools haven’t been incorporated directly into the application. Until someone takes the time to code the tools into GnuCash, we users have limited options available to obtain these data.
> 
> David
> 
>> On Jun 20, 2016, at 9:47 AM, Jim Vincent <jimvincent2 at comcast.net> wrote:
>> 
>> David -
>> You said 
>> ” However, before you go down that rabbit hole, perhaps you want to consider other means? GnuCash is designed firstly as an accounting   app, and thus its focus is on actual transactions (as opposed to important, but not real, valuations). In other words, GnuCash works very well to document the value at which you purchased your stocks, and the value at which you sell them, but its toolset is not as useful for tracking valuation of holdings over multiple time periods. You might be trying to use a hammer to put in a screw."
>> But the income statement shows unrealized gains or losses - which implies the values on the balance sheet are at market, not cost.
>> So if I want accurate data for past periods, don't I need market prices for securities at those time?
>> Jim
>> -----Original Message-----
>> From: David T. [mailto:sunfish62 at yahoo.com] 
>> Sent: Tuesday, June 7, 2016 8:47 AM
>> To: Jim Vincent <jimvincent2 at comcast.net>
>> Cc: david.carlson.417 at gmail.com; gnucash-user at gnucash.org
>> Subject: Re: Help importing historical stock prices
>> 
>> The wiki page includes the necessary scripts to gather and insert historical prices into a GnuCash file. I believe that you will need to have compiled GnuCash with python enabled, which will depend on the operating system you use.
>> 
>> However, before you go down that rabbit hole, perhaps you want to consider other means? GnuCash is designed firstly as an accounting app, and thus its focus is on actual transactions (as opposed to important, but not real, valuations). In other words, GnuCash works very well to document the value at which you purchased your stocks, and the value at which you sell them, but its toolset is not as useful for tracking valuation of holdings over multiple time periods. You might be trying to use a hammer to put in a screw.
>> 
>> If the reason you are trying to get these historical values is to establish the past value of your portfolio, it might be easier to use a spreadsheet to do this. I know that you can set up a Google Sheet with embedded functions that will quickly and easliy retrieve stock prices—without python or perl scripts. An hour or two (or three) experimenting in that might give you what you need more quickly.
>> 
>> David
>> 
>>> On Jun 7, 2016, at 8:26 AM, Jim Vincent <jimvincent2 at comcast.net> wrote:
>>> 
>>> There is finance-quote script. I was hoping that I could use that to get the prices and get them into gnu-cash. The amount of data is not a big concern – although there are a lot of stocks (maybe a hundred), I just need year-end data for the past six years, plus data for a starting point. I need the list of stocks to input to finance-quote, along with a list of the dates I need data for. 
>>> 
>>> I am willing to pay if someone can help me.
>>> 
>>> Jim Vincent
>>> 
>>> 
>>> 
>>> 
>>> 
>>> From: david.carlson.417 at gmail.com [mailto:david.carlson.417 at gmail.com] 
>>> Sent: Tuesday, June 7, 2016 7:29 AM
>>> To: jimvincent2 at comcast.net; gnucash-user at gnucash.org
>>> Subject: Re: Help importing historical stock prices
>>> 
>>> 
>>> 
>>> Jim
>>> 
>>> There is no easy way to do that.  If someone has written a script to do that perhaps they can tell us about it.
>>> 
>>> Adding a lot of price history to the data would just make the file huge anyway.
>>> 
>>> 
>>> 
>>> I sometimes add a few prices manually if I want them for a certain report.  
>>> 
>>> 
>>> 
>>> David C
>>> 
>>> 
>>> 
>>> Sent from my LG G Pad 7.0 LTE, an AT&T 4G LTE tablet
>>> 
>>> 
>>> 
>>> ------ Original message------
>>> 
>>> From: Jim Vincent
>>> 
>>> Date: Mon, Jun 6, 2016 8:46 PM
>>> 
>>> To: gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org> ;
>>> 
>>> Subject:Help importing historical stock prices
>>> 
>>> 
>>> 
>>> I need help importing historical stock prices.Jim Vincent_______________________________________________gnucash-user mailing listgnucash-user at gnucash.orghtt <mailto:%20listgnucash-user at gnucash.orghtt> ps://lists.gnucash.org/mailman/listinfo/gnucash-user-----Please <http://lists.gnucash.org/mailman/listinfo/gnucash-user-----Please>  remember to CC this list on all your replies.You can do this by using Reply-To-List or Reply-All.
>>> _______________________________________________
>>> gnucash-user mailing list
>>> gnucash-user at gnucash.org
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> -----
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>> 
>> 
> 
> 