Search found 11 matches

by Jenga
13 Jan 2011, 06:06
Forum: Help
Topic: Create an OFX file from an Excel Export
Replies: 3
Views: 34429

Create an OFX file from an Excel Export

My bank allows me to export my movements only in Excel format. So I did a little search, copy, paste and some adaptation to create an Excel macro that generates an OFX file that can be imported in Finance Explorer, starting from the Excel file provided by my bank. I took the original code from here:...
by Jenga
03 Jan 2011, 03:17
Forum: Help
Topic: Total not working on investment
Replies: 3
Views: 18155

Re: Total not working on investment

I found another issue in totals: I copied budget from previous month, and in the budget page, it doesn't sum correctly.
The total of the first column should be -535 too.
See image.
Image
by Jenga
21 Dec 2010, 07:06
Forum: Help
Topic: Something strange with Italian locale
Replies: 10
Views: 22195

Re: Something strange with Italian locale

I downloaded and tested it
It works fine.
I just have to remember to write numbers with decimals using "," and not the NumPad "."

Great!
by Jenga
16 Dec 2010, 05:24
Forum: Help
Topic: Total not working on investment
Replies: 3
Views: 18155

Total not working on investment

I am trying to add my stock quotes to the investment section. I did a test like it is explained in the tutorial: Now select your newly added account and enter "IBM" in the Symbol column, 1000 for the quantity and $50 for a Purchase Price. Go to Tools->Update Quotes and see how the current ...
by Jenga
16 Dec 2010, 00:14
Forum: Help
Topic: Again on importing data
Replies: 6
Views: 15602

Re: Again on importing data

About help: I'm having a look to the tutorial page http://www.metalogicsw.com/financeexplorer/tutorial/
It looks like the section 5 setting up investment is truncated... Or is it correct?
by Jenga
14 Dec 2010, 04:36
Forum: Help
Topic: Again on importing data
Replies: 6
Views: 15602

Re: Again on importing data

I took the original code from here: http://money.mvps.org/faq/article/540.aspx The link to the arrticle doesn't work any more but at the end of the page there is a link to a zip file: http://money.mvps.org/downloads/files/XLS2OFX.zip I changed a little the macro to meet the requiremenst for MFE. I w...
by Jenga
13 Dec 2010, 03:13
Forum: Help
Topic: Again on importing data
Replies: 6
Views: 15602

Re: Again on importing data

I think I solved: there where some CR+LF at the end of some lines.
Replaced them with LF solved this issue!
by Jenga
13 Dec 2010, 01:28
Forum: Help
Topic: Again on importing data
Replies: 6
Views: 15602

Again on importing data

I have problem importing data from my bank account. Unfortunately my bank allows me to download excel file of transactions. I found a macro in Excel that generate an .OFX file from the Excel. I found that the extra spaces are not handled by MFE (I saw a different thread on this) so I changed the mac...
by Jenga
13 Dec 2010, 00:51
Forum: Help
Topic: Something strange with Italian locale
Replies: 10
Views: 22195

Re: Something strange with Italian locale

I did a little more tests on this. Locale set to italian standard (so "." and "," behaviour different from english). If I type a value like you suggested (for example "200,05") it loads in the list, but after changing focus it shows "20.005,00" So I see a numb...
by Jenga
11 Dec 2010, 00:32
Forum: Help
Topic: Something strange with Italian locale
Replies: 10
Views: 22195

Re: Something strange with Italian locale

Yes, this solves the issue, but it messes up Excel and Access behaviour.

Go to advanced search