trouble with date when importing a just exported csv file.

[Edward Doolittle]

In North America SEC and OSC have a "T+3" rule for settling trades, which gives the buyer of securities three days to deposit any cash required for a purchase. While not exactly "buying on credit", it means that one does not in general need the cash in the brokerage account in order to buy securities, even in a cash/non-margin account.

Sent from my iPad

> On Jan 27, 2015, at 3:18 PM, David Carlson <david.carlson.417 at gmail.com> wrote:
> 
>> On 1/27/2015 1:20 PM, Larry Evans wrote:
>>> On 01/27/2015 11:45 AM, David Carlson wrote:
>>>> On 1/27/2015 10:30 AM, Larry Evans wrote:
>>>> Using an account tree containing just a checking account and one stock
>>>> account for stock SHA1, I bought 1 share on 2015-01-01, then exported
>>>> the account transactions to a csv file.  I changed the date of the
>>>> buy in the .csv file toe 2015-02-01 and tried to import it.
>>>> I specifyied the date field and y-m-d, but when the import ran,
>>>> I got some error message about possibly the date field being wrong.
>>>> On import, I specified no quotes and @ and the separated.
>>>> The exported file is at bottom delimited by --{--- and --}---.
>>>> 
>>>> My OS is ubuntu 14.04 and my gnucash is 2.6.1.
>>>> 
>>>> How can I import these transactions?
>>>> 
>>>> TIA.
>>>> 
>>>> -regards,
>>>> Larry
>>>> 
>>>> --{-------import_export.csv---
>>>> Date at Account
>>>> Name at Number@Description at Notes@Memo at Category@Type at Action@Reconcile at To
>>>> With Sym at From With Sym at To Num. at From Num. at To Rate/Price at From Rate/Price
>>>> 2015-02-01 at Checking Account@@buy 1@@@SHA1 at T@@N at -$100.00@@-100.00@@@
>>>> @@@@@@SHA1 at S@Buy at N@@1 SHA1@@1@@100
>>>> @@@@@@Checking Account at S@@N at -$100.00@@-100.00@@1.00@
>>>> 2015-02-01 at SHA1@@buy 1@@@Checking Account at T@Buy at N@1 SHA1@@1@@@
>>>> @@@@@@SHA1 at S@Buy at N@1 SHA1@@1@@100@
>>>> @@@@@@Checking Account at S@@N@@-$100.00@@-100.00@@1.00
>>>> --}-------import_export.csv---
>>>> 
>>>> _______________________________________________
>>>> 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.
>>>> 
>>> Slow down.  I suggest going one step at a time.
>>> 
>>> It looks like you are a new user trying to test GnuCash.  Either you
>>> skipped several steps or you just didn't mention them in your message.
>>> 
>>> Investment transactions issues are not easy to troubleshoot if mixed up
>>> with import export issues. 
>>> 
>>> I suggest first reading the Tutorial and Concepts Guide and setting up
>>> your chart of accounts similar to the samples  After you have the basics
>>> down, go to the import section of the help manual if you plan to import
>>> data from some outside source. 
>>> 
>>> After all of that, go to the investments chapter of the Tutorial and
>>> Concepts Guide and set up your test accounts correctly with security
>>> accounts under a asset:brokerage account.  Feel free to ask simple
>>> questions that you think will get short answers.
>>> 
>>> David C
>> Thanks David,
>> 
>> Although I'm new to export/import to csv, I've been using gnucash
>> for several years.  Howver, you are right that I am testing
>> gnucash, but only the import/export part.  I tried on my real
>> data; however, I got the same error.  Thus I decided to simplify.
>> 
>> 
>> I've attached several .png files detailing in sufficient detail,
>> hopefully, what's happening.  The leading number in the filename
>> indicates the order in which the depicted actions were taken.
>> 
>> TIA for any insight you could provide.
>> 
>> -regards,
>> Larry
>> 
>> 
>> 
>> 
>> _______________________________________________
>> 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.
> 
> I am a user who has never experimented with csv so I will defer to
> others on that part, but it appears that you did not construct your
> purchase transaction correctly, unless your broker allows you to buy
> stock on credit.  Even if he does, there would be margin transactions. 
> My broker wants me to deposit cash into my brokerage account before I
> can buy stock.
> 
> David C
> _______________________________________________
> 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.