Re: [GNC] Manipulating data extracted from gnucash to Excel

Only because I don't have any keyboard shortcuts memorized except ctrl-c and ctrl-v. On Sun, May 19, 2024 at 11:25 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Any reason not to use CTRL+A? > > Regards, > Adrien > > On 5/19/24 9:08 PM, Joseph Keithley wrote: > > If the whole

Re: [GNC] Can't download stock prices

Thanks John, I ran the below commands and this is what I got. Ernie@Ernie-Mac-mini contents % spctl --assess -vv /applications/gnucash.app /applications/gnucash.app: accepted source=Notarized Developer ID origin=Developer ID Application: John D Ralls (Y9EHT5WMK7) Ernie@Ernie-Mac-mini contents %

Re: [GNC] Easier way to print to PDF

On 2024-05-19 16:29, Joseph Keithley wrote: > If you are on a Windows machine you can use the Windows built-in PDF > printer driver (Settings > Devices > Printers > Add Printer - "Microsoft > Print to PDF"). Caution! Microsoft Print to PDF makes huge, bloated PDF files. A one-page simple

Re: [GNC] Manipulating data extracted from gnucash to Excel

Open the report in Excel and _then_ do your copy and pasting. (You probably want Edit » Paste Special » Values, keyboard Alt+E, S, V.) Stan Brown Tehachapi, CA, USA https://BrownMath.com On 2024-05-19 17:35, David Long wrote: > Hi > I mean copy paste from a gnucash report. > Rgds > David > >

Re: [GNC] Can't download stock prices

> On May 19, 2024, at 18:03, Ernie Wakamatsu wrote: > > Hi, > > First time user of this mailing list and just starting to use gnucash. Been > transferring information over from Quicken and I am getting things close to > the way I would like. > > I am trying to download stock prices, but

Re: [GNC] Manipulating data extracted from gnucash to Excel

Any reason not to use CTRL+A? Regards, Adrien On 5/19/24 9:08 PM, Joseph Keithley wrote: If the whole left-click hold copy and drag doesn't work well, there is an alternate method. When you move the mouse cursor to the top left of the tab, move the cursor slowly to the right until the mouse

Re: [GNC] Manipulating data extracted from gnucash to Excel

If the whole left-click hold copy and drag doesn't work well, there is an alternate method. When you move the mouse cursor to the top left of the tab, move the cursor slowly to the right until the mouse cursor changes from an arrow to a line (assuming your PC set up is similar to mine) and

Re: [GNC] Manipulating data extracted from gnucash to Excel

Understood. I can tell you what I do with copy/pasting a paticular report. I've never had a problem with double quotes. In my case, I copy/paste the "Investment Portfolio" report under "Assets and Liabilities" to Excel. When the tab opens with the report, I put the mouse cursor on the top left

[GNC] Can't download stock prices

Hi, First time user of this mailing list and just starting to use gnucash. Been transferring information over from Quicken and I am getting things close to the way I would like. I am trying to download stock prices, but getting the following errors. Ernie@Ernie-Mac-mini ~ %

Re: [GNC] Manipulating data extracted from gnucash to Excel

Hi I mean copy paste from a gnucash report. Rgds David On Mon, 20 May 2024, 04:13 Joseph Keithley, wrote: > Not sure what you mean by "copy". In the Windows version of GnuCash 5.5 > you can export your accounts to a csv file. You pick the account, the date > range, and the separator

Re: [GNC] Easier way to print to PDF

If you are on a Windows machine you can use the Windows built-in PDF printer driver (Settings > Devices > Printers > Add Printer - "Microsoft Print to PDF"). Alternatively, you can export the report (shows up as an .html) and open it with Microsoft Edge and save it as a PDF. On Sun, May 19,

[GNC] Easier way to print to PDF

A few years ago, when you wanted to print to PDF a report, it started in the last directory used.  It was then changed to basically go through the print dialogue and start in home directory, which wastes a lot of time. I do now notice there is a "make PDF" icon that does nothing but bring up the

Re: [GNC] Delete a trading account => crash

By mistake, I had two Asset accounts for the same stock, but with different spellings. That is what produced the two similar Trading accounts. So, I ended up doing in the Cash account that did the buys and sells: In split view mode: change the stock asset account from one to the other, press

Re: [GNC] Manipulating data extracted from gnucash to Excel

Not sure what you mean by "copy". In the Windows version of GnuCash 5.5 you can export your accounts to a csv file. You pick the account, the date range, and the separator (usually a comma). There is also an option to either add double quotes or not. On Sun, May 19, 2024 at 12:41 PM David Long

Re: [GNC] Manipulating data extracted from gnucash to Excel

And if your currency is using character strings ("USD", "CHF", etc.), you can customize the currency designator so that Excel can process them. ⁣David T. ​ On May 19, 2024, 8:50 PM, at 8:50 PM, "Stan Brown (using GC 4.14)" wrote: >On 2024-05-19 09:39, David Long wrote: >> When I copy data

Re: [GNC] Saved Reports accross several PCs

On 2024-05-19 09:35, David Long wrote: > I am running gnucash on more than one PCs. When I create report on one PC I > find I have create that report on other PC even though they are both > pulling in data from the same file. Is there anything I can do to not have > recreate these reports?. Sure

Re: [GNC] Manipulating data extracted from gnucash to Excel

On 2024-05-19 09:39, David Long wrote: > When I copy data from Gnucash to Excel it arrives on text format along with > the currency denomination, so I cannot then manipulate it in Excel. > Is there anyway I can export data to Excel in data format?. > Thanks > David Hi, David! Which "data" are

Re: [GNC] All Reports Crashing Version 5.6-1

> On May 19, 2024, at 01:05, Rodney Harrex via gnucash-user > wrote: > > Running any report will crash GnuCash. In > C:\Users\Rodney\AppData\Local\Temp. Any of the reports selected will appear > as HTML file along with a file like > > gnucash.trace.ITONN2.log with the content: 17:31:13

Re: [GNC] Delete a trading account => crash

> On May 18, 2024, at 22:04, Fred Tydeman wrote: > > Running GnuCash 4.14 on Fedora Linux. > > Due to a mistake on my part, I have two Trading accounts: > IVR-PC > IVRPRC > for the same security. > > First, I tried changing Trading:IVRPRC to Trading:IVR-PC in a Sell or Buy > transaction

[GNC] Manipulating data extracted from gnucash to Excel

When I copy data from Gnucash to Excel it arrives on text format along with the currency denomination, so I cannot then manipulate it in Excel. Is there anyway I can export data to Excel in data format?. Thanks David ___ gnucash-user mailing list

[GNC] Saved Reports accross several PCs

I am running gnucash on more than one PCs. When I create report on one PC I find I have create that report on other PC even though they are both pulling in data from the same file. Is there anything I can do to not have recreate these reports?. Also, I am using Gnucash for 2 different

Re: [GNC] Delete a trading account => crash

That is the behavior, sadly, where it goes back to what the original transaction was. It is undesired but it is there and not likely to be fixed.. (I run into it when I want to duplicate the transaction and then just update the quantity) To get around, you technically have to enter the entire

Re: [GNC] Accounts page error

I have seen "overnight" massive gains when there's been a stock split I wasn't aware of, a 10 to 1 reverse split, or something like that. Usually it is the opposite effect of what you are seeing, where suddenly I'm down a lot of net worth. The only other thing I can think of is that maybe one

[GNC] All Reports Crashing Version 5.6-1

Running any report will crash GnuCash.  In C:\Users\Rodney\AppData\Local\Temp.  Any of the reports selected will appear as HTML file along with a file like gnucash.trace.ITONN2.log with the content: 17:31:13  WARN [taxtable_reset_refcount()] Fixing refcount on taxtable