Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #2  
Old 01-02-2004, 07:49 AM
John
Guest
 
Posts: n/a
Default Importing an Excel file into Money

Something else I thought of after reading a few post.
After you perform the above on an investment account,
Money will use your purchase as a price for tracking. You
can then look back at the performance. This is very
important to me since my 401k does not have a tracker
symbol.

Also if you get your qif ready and you import it use the
"as a new or recovered accout" There is more information
in the help files about this.


- quote -

> -----Original Message-----
> I do my banking with Smith Barney. Although I could
> download directly into Money (or Quicken) there is a
> monthly charge to do this. I don't want to use Money or
> Quicken to pay my bills, simply to organize my finances
> better.
> I am able to download my account data into Excel. Is
> there anyway I can import from Excel into Money? I tried
> doing this using the import feature, but nothing happened
> when I selected the Excel file and clicked import (no
> error messages or anything).
> .

  #1  
Old 01-02-2004, 07:38 AM
John
Guest
 
Posts: n/a
Default Importing an Excel file into Money

I also needed this feature, I have found a way and it
works great...at least for me. I copy the data from my
web site and paste it into excel. I have written a macro
which will take the data and convert it to qif format. I
then copy the data from excel and paste it in notepad and
save it as a .qif I then simple import the file into
money and I have the entire years records for my 401k. I
also do this for a credit card which charges for the
download but the data is free on the web.

You can write your own macro if you study the qif format.
It follows a banking standard for transaction formatting.

I arrange my pasted data in columns, then have my vbmacro
copy/format/and paste the data on sheet2 of the workbook.
the output will look something like this.

!Type:Invst
D12/26'2003
YCore Bond Fund
MBasic Before-Tax
T17.26
I11.2
NBuy
Q1.541
^
D12/26'2003
YCore Bond Fund
MEmployer Match
T4.32
I11.2
NBuy
Q0.386
^

For me it was worth the time needed to write the macro, I
now can Copy a years worth of data, convert it,import it,
and have it available in minutes. It took about three
days for me to find the info, make the connection (which I
am telling you about) and write the macro. I'm sure there
are some programmers out there that could really write
some nice macros for this. I am not a programmer but was
able to do it.

I also believe they should include this function with
money somehow

Hope this helps

If you want more information, post back here, I will check
back

- quote -

> -----Original Message-----
> I do my banking with Smith Barney. Although I could
> download directly into Money (or Quicken) there is a
> monthly charge to do this. I don't want to use Money or
> Quicken to pay my bills, simply to organize my finances
> better.
> I am able to download my account data into Excel. Is
> there anyway I can import from Excel into Money? I tried
> doing this using the import feature, but nothing happened
> when I selected the Excel file and clicked import (no
> error messages or anything).
> .

 
Old 12-28-2003, 03:48 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Importing an Excel file into Money

In microsoft.public.money, Cruzin wrote:

- quote -

> I do my banking with Smith Barney. Although I could
> download directly into Money (or Quicken) there is a
> monthly charge to do this. I don't want to use Money or
> Quicken to pay my bills, simply to organize my finances
> better.
> I am able to download my account data into Excel. Is
> there anyway I can import from Excel into Money? I tried
> doing this using the import feature, but nothing happened
> when I selected the Excel file and clicked import (no
> error messages or anything).


See FAQ available at http://www.bollar.org/msmoney/ and search for
excel.
  #-1  
Old 12-28-2003, 03:16 PM
Cruzin
Guest
 
Posts: n/a
Default Importing an Excel file into Money

I do my banking with Smith Barney. Although I could
download directly into Money (or Quicken) there is a
monthly charge to do this. I don't want to use Money or
Quicken to pay my bills, simply to organize my finances
better.

I am able to download my account data into Excel. Is
there anyway I can import from Excel into Money? I tried
doing this using the import feature, but nothing happened
when I selected the Excel file and clicked import (no
error messages or anything).
 

Tags
excel, file, importing, money
Similar Threads
Thread Forum Replies Last Post
Importing Payees from Excel into Money
neck621: Can I import payees from any other file format such as Excel into Money?
Microsoft Money 1 11-21-2003 12:17 AM
Money -- import of Excel File of Transactions ...
jkotecha: I'm having trouble reconciling my account on line. So I was able to download the account into Excel and "fixed" my transactions that way. How do I...
Microsoft Money 2 11-20-2003 02:15 PM
Importing a CSV file into Money 2003
Gator_D: Help! I'm trying to import all of my brokerage account activity either as a Microsoft native format CSV file or Quicken .QIF file into my...
Microsoft Money 1 09-07-2003 05:35 PM



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

All times are GMT. The time now is 02:46 AM.