Re: [GNC] Account Types -- what are the implications of getting them wrong?

Thank you David. Would it be correct for me to assume that *any* account type can be edited prior to the addition of any data? Either way, it sounds like this can be an iterative process to an extent. And that most negative consequences can be reversed with a little creativity. Tim > On Feb

Re: [GNC] Account Types -- what are the implications of getting them wrong?

Thanks Jim for the reply. > On Feb 20, 2023, at 15:49, Jim DeLaHunt wrote: > > It sounds like you are trying to answer two questions: > > 1. How do you extract meaning from account name strings in incoming migration > data, such that you can pick the appropriate GnuCash account type? Ummm,

[GNC] Account Types -- what are the implications of getting them wrong?

The approach I’m taking in a migration app I’m writing will be conservative, erring on the side of more general vice more specific. For example, ASSET, LIABILITY, INCOME, EXPENSE, EQUITY are pretty easy to accurately apply based on account names (for example, “assets:current assets:cash”). In

Re: [GNC] Entered Date, UX Question

Thank you! Yeah, the more I’ve been thinking about this and researching what Quicken does, I think it makes more sense to have the `entered_date` be the timestamp the transaction is imported. Where I’m finding I still have to investigate, discuss and ponder is that Quicken has a Date field,

[GNC] Entered Date, UX Question

Hello! I’m writing an app to help people migrate to GnuCash (primarily from Quicken, in my case Quicken for Mac), and I’m using PieCash to write sqlite3 file. I’ve read/searched the docs, and so I believe I understand the concept of a transaction entry date into an accounting system, and that

Re: [GNC] Website Down?

Excellent. So discovered. Thank you. > On Feb 2, 2023, at 14:17, Derek Atkins wrote: > > You can get to the docs through the wiki (which IS up). > > -derek > > On Thu, February 2, 2023 3:12 pm, m...@tgr66.me wrote: >> Thanks! I was just trying to get to the docs to understand the account >>

Re: [GNC] Website Down?

Thanks! I was just trying to get to the docs to understand the account types, but I pulled them from the app which is close enough for now. I appreciate you and Linas. > On Feb 2, 2023, at 14:10, Derek Atkins wrote: > > Hi, > > The www.gnucash.org server is hosted out of Austin, TX. > With

[GNC] Website Down?

Here in the US, Texas, I’m not able to reach the gnucash.org. I’m able to reach other websites. Anyone else experience this? Tim ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe:

Re: [GNC] Budget report fails in multiple currencies

ion during the budget period part of the result. In the language of my last e-mail, this pull request computes "ES_12*X_1" (but perhaps it should be "ES_12*X_2"... to be discussed). https://github.com/Gnucash/gnucash/pull/1497 On Sun, Jan 8, 2023 at 9:34 AM ml enquirer wrote:

Re: [GNC] Budget report fails in multiple currencies

Yes, it's cumulative, which is a problem I think. Let: 0 indicate the opening of the book 1 indicate the start of the budget period in question 2 indicate the end of that period S_i indicates the sum of transactions since 0 at marker i, in the currency of the sub-account P_i indicates the sum of

Re: [GNC] OFX Requirements

I’ll check it out. Thanks. > On Jan 7, 2023, at 17:54, Jean L wrote: > > Also, this > > https://github.com/jrwrigh/csv2cash > Could be the answer to what you're trying to do? > > Jean > > On 1/7/2023 12:51 PM, Tim Rohrer wrote: >> >> >>> On Jan 7,

Re: [GNC] Budget report fails in multiple currencies

at least for expense accounts if not for asset accounts ;) But as I keep on saying, I'm very ignorant of even basic accountancy techniques, so feel free to (gently) teach me! D On Sat, Jan 7, 2023 at 6:08 PM Fred Bone wrote: > On 07 January 2023 at 10:21, ml enquirer said: > > &

Re: [GNC] Budget report fails in multiple currencies

uot; spend will be 10,000 GBP despite nothing having been spent. This reporting bug gets worse the longer gnucash is used. Thanks, D On Sat, Jan 7, 2023 at 9:52 AM ml enquirer wrote: > Hi Adrien, > > Thanks for the mental bandwidth on this. I don't like replying inline, but > I'm

Re: [GNC] Budget report fails in multiple currencies

ference) > No trading accounts. > > - > I've been in the habit of hazarding guesses lately, so here's one for > this topic: > > Since the Budget Report does not have an option for commodity price > source like other reports cognizant of other currencies, I'll > hypot

Re: [GNC] Budget report fails in multiple currencies

ant that the balance of "Groceries" was (10,000GBP+10,000GBP)+(10,000GBP+10,000GBP)+(10,000GBP+10,000GBP) = 60,000 GBP. Difference 30,000 GBP. so 1 + 1 = 3. On Thu, Jan 5, 2023 at 9:37 PM ml enquirer wrote: > Hi! > > Any clues as to where to start to understand this odd budget repor

Re: [GNC] Register column sizing

I’m new to GnuCash so I admit I’m not sure I fully understand the question’s impacts. I have figured out I can resize each column manually, but what does confuse me is why (at least on macOS) a double click (as opposed to a right-click) activates what I believe you’re referring to as

Re: [GNC] QIF format for StkSplit

Yes. In my GnuCash the original shares are removed in one transaction, and the newly calculated amount (based on the split) is added in a second transaction. In my Quicken, when I recorded a split, the additional shares (in this case, a 4 for 1 of APPL) were recorded. But my original question

Re: [GNC] QIF format for StkSplit

I appreciate the analysis of the code, and the confirmation of what I found through experimentation. I had tried searching the code for the answer, but I do not know C/C++ and I would not have been able to figure it out. I’d be happy to write a paragraph documenting how a QIF entry for a

Re: [GNC] QIF format for StkSplit

So, the ratio * 10 does seem to be working. :man_shrugging: For example, if it is a 4 for 1 split, 40 If it is a 1 for 10 split, 1 > On Jan 5, 2023, at 14:17, m...@tgr66.me wrote: > > Yes. I missed adding that to the list I’ve tried. > > In the full work minimal example below, the share

Re: [GNC] Budget report fails in multiple currencies

in such an apparently-illogical (but presumably profoundly reasonable to a better-informed person!) way... Hints very much appreciated! On Mon, Jan 2, 2023 at 4:10 PM ml enquirer wrote: > Dear all, > > I spend in two currencies and, historically, I chose to create separate > account

Re: [GNC] QIF format for StkSplit

Yes. I missed adding that to the list I’ve tried. In the full work minimal example below, the share balance ends up at 1.2 !Account NAssets:Investments:Brokerage Account:Joint Brokerage TInvst ^ !Type:Bank D01/11/2020 NPayment/Deposit PTrf My Bank CX T1,000.00 MDeposit LAssets:Current Assets:My

[GNC] QIF format for StkSplit

I’ve searched considerably, but if I missed it, I apologize. Docs for QIF say the Q field should contain the split ratio. I’ve tried various options, but I’m not getting the expected results after import. !Type:Invst D8/31/2020 NStkSplit PAPPLE INC YAAPL CR M4 for 1 split; Q36 // Have also

Re: [GNC] Missing "Buy" action after import of QIF file

Thank you both. I’ll work on a report. > On Jan 4, 2023, at 07:00, Kalpesh Patel wrote: > > I stand corrected as well. The Action column is never updated with the action > denoted in the qif file. Nonetheless the right side buy and sell columns do > reflect correct transaction (which Derek

Re: [GNC] Missing "Buy" action after import of QIF file

This is what I would expect to see. Note the “Buy” in the Action field. However, I had to add that as the QIF import process doesn’t appear to be doing it. Thank you. > On Jan 3, 2023, at 18:50, Derek Atkins wrote: > > Screen cap came through (at least to me) -- but you cut out too much

Re: [GNC] Missing "Buy" action after import of QIF file

Yes. Trying again to paste a screen cap. I also tried on my Linux box and got the same result. No action showing. > On Jan 3, 2023, at 18:27, Derek Atkins wrote: > > Are you in double-line mode? If not, try turning that on.. > > -derek > > On Tue, January 3, 2023 7:16 pm, m...@tgr66.me

Re: [GNC] Missing "Buy" action after import of QIF file

I only included the snippet relevant to the question; my real file has the header lines and carets. The back ticks were included because I’m used to using those to show a code block :-) They’re not in the real file. I’ll include the entire test file at the end of this message. So I just double

Re: [GNC] Missing "Buy" action after import of QIF file

Oops, I guess the mailing list doesn’t show attached images. > On Jan 2, 2023, at 19:51, m...@tgr66.me wrote: > > In my import file: > > ``` > !Type:Invst > D12/2/2022 > NBuy > PXYZ, INC > YXYZ > I150 > T450 > Q3 > CR > M3 shares @ 150; Nothing to see here > ``` > > Import and GnuCash creates

[GNC] Missing "Buy" action after import of QIF file

In my import file: ``` !Type:Invst D12/2/2022 NBuy PXYZ, INC YXYZ I150 T450 Q3 CR M3 shares @ 150; Nothing to see here ``` Import and GnuCash creates the correct account, but notice the lack of a “Buy” action: Is this a known issue or am I misunderstanding the need for the action to be

Re: [GNC] Date format for QIF file

Thanks Kalpesh— I’m on a Mac and Quicken doesn’t have a QIF export, only CSV. I’m writing a NodeJS app/lib to convert csv exports to QIF. The dates in the csv are consistently M/D/. I can export non investment accounts to QMTF which is a QIF but certain fields (like tags) aren’t

Re: [GNC] How to "Get Quotes" for a specific day?

Hi Michael, I've faced the same problem. I use the gnucash python bindings and the following script, to import prices from a text file which has date (-MM-DD) and price with a new date on each line. Hope it could be some use. As always, test it before deploying! Best wishes. ```python

[GNC] Budget report fails in multiple currencies

Dear all, I spend in two currencies and, historically, I chose to create separate accounts under each expense line for each currency. In future I will do this differently, employing trading accounts, but what I'm about to describe should still work. I budget in my 'home' currency, and the budget

Re: [GNC] Scrubbing workflow

Assuming one creates a separate account to track each stock (for example, “Joint Brokerage:AAPL” and “Joint Brokerage:AMZN” doesn’t a user have to scrub for each symbol? Or am I misunderstanding and it *should* work at the “Joint Brokerage” level? > On Dec 29, 2022, at 20:04, Geoff wrote: >

[GNC] Scrubbing workflow

I searched the mailing list and didn’t really get any hits from the past six years, so I’m starting a new thread. I understand the concept of lots, and I *think* I understand _why_ GnuCash uses the scrubbing concept (i.e., internationalization?). In any case, I’m a little worried about the

Re: [GNC] Date format for QIF file

Thank you Derek, I understood *why* it was happening, and I do realize that in reality, as the file size grows, the chance of having all days <= 12 is pretty darn slim :-) I appreciate the quick response. Tim > On Dec 29, 2022, at 12:55, Derek Atkins wrote: > > Not particularly. > The

[GNC] Date format for QIF file

I’m developing QIF files to import my old investments. I get asked every time to confirm the date format (the entire import process is a bit long imo). The QIF specification says I ought to be able to enter a date using `dd month year`; for example: 29 December 2022. However, this results in an

Re: [GNC] Unable to retrieve currency quotes

rities (but no other currencies, I think) set up. I'll try debugging by disabling one by one and let you know how I get on. All the best, On Sat, May 19, 2018 at 7:39 PM, John Ralls <jra...@ceridwen.us> wrote: > > > On May 19, 2018, at 9:10 AM, ml enquirer <ml.hnel.227...@gma

Re: [GNC] Unable to retrieve currency quotes

Hi all, @shaq32: thanks for the idea, but no, this is not the problem, I already have a valid API key (that's a very old FAQ...) Any luck debugging, John? Anything I can do to provide more useful info? Best regards, On Tue, May 8, 2018 at 7:31 PM, shaq32 wrote: > Hi, >

Re: [GNC] Unable to retrieve currency quotes

Thanks - it's reassuring to know it's not just me... all the best, On Mon, Apr 30, 2018 at 10:18 PM, John Ralls <jra...@ceridwen.us> wrote: > > > > On Apr 30, 2018, at 1:05 PM, ml enquirer <ml.hnel.227...@gmail.com> > wrote: > > > > Sorry, that sh

Re: [GNC] Unable to retrieve currency quotes

or message. Is AlphaVantage really very unstable? I tried with a new API key but with no luck. On Mon, Apr 30, 2018 at 10:05 PM, ml enquirer <ml.hnel.227...@gmail.com> wrote: > Sorry, that should have read GnuCash 3.1... > > D > > > On Mon, Apr 30, 2018 at 9:59 PM, ml enquirer

Re: [GNC] Unable to retrieve currency quotes

Sorry, that should have read GnuCash 3.1... D On Mon, Apr 30, 2018 at 9:59 PM, ml enquirer <ml.hnel.227...@gmail.com> wrote: > Hi, > > I have GnuCash 2.6.21 for Mac (running 10.13.4). I have set up > Finance::Quote properly, with my alphavantage key. When I press "Get

[GNC] Unable to retrieve currency quotes

Hi, I have GnuCash 2.6.21 for Mac (running 10.13.4). I have set up Finance::Quote properly, with my alphavantage key. When I press "Get quotes" in the Price Editor, I expect updates for CHF, EUR and several stock quotes. The stock quotes come back fine each time, but the two currency updates fail

Re: yahoo as json stock quotes pounds/pence

ear what more experienced people have to say! Thanks, Dan On Thu, Jan 25, 2018 at 11:55 PM, ml enquirer <ml.hnel.227...@gmail.com> wrote: > Hi, > > I'm aware this is not a new question: > - https://lists.gnucash.org/pipermail/gnucash-user/2008- > November/027224.html >