search

slew77 / hle-ofx-quotes

Automatically exported from code.google.com/p/hle-ofx-quotes
0 stars 1 forks source link

Add cvs-to-csv mapper file to allow CSV import from other quote source/provider #31

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago 
what would be cool would be a feature similar to mapper.csv which allowed 
mapping of the headers from Hargreaves Lansdown (or any other service) to that 
of Money

From:-

Portfolio Summary

Client Name: Mr Paul Rogers

Client Number: xyz

Valuation as at 25/06/2011 14:28

Code Stock Units held Price (p) Value (£) Cost (£) G/L (£) G/L (%) 3322819

Aberdeen Emerging Markets Accumulation Shares 1 516.22 5.16 5.07 0.09 1.78 
B1419R5???

Aegon Investment Grade Bond Fund Income 1 98.22 0.98 0.98 n/a n/a

To:-

Name Symbol: Exchange Quote Date & Time Last Price Currency for Last Price

Aberdeen Emerging Markets Accumulation Shares 3322819 Jun 25 2011 14:28 GMT 
516.22 GBX

Aegon Investment Grade Bond Fund Income B1419R5??? Jun 25 2011 14:28 GMT 98.22 
GBX

This is not an issue for me as I have already created Excel macros to do this 
for me however it does open up the project to more potential users?

For other users I am using:- Money 2002 Financial Suite (UK edition) running 
windows 7 64bit

Regards

Original issue reported on code.google.com by hle...@gmail.com on 27 Jun 2011 at 2:54

GoogleCodeExporter commented 8 years ago 
Just as an FYI,

As an example I have attached a stock price download from Hargreaves & 
Lansdown, let me know if you need any further info or if I can help in any way

Original comment by progers...@hotmail.com on 27 Jun 2011 at 5:24

Attachments:

GoogleCodeExporter commented 8 years ago 
This will be awesome . I am thinking if we can get the csv from Yodlee and 
convert them to OFX to be imported in MS money.

Original comment by uman...@gmail.com on 19 Jul 2011 at 7:07

GoogleCodeExporter commented 8 years ago 
Can I see the code of macro that convert csv to ofx entry

Original comment by uman...@gmail.com on 19 Jul 2011 at 7:08

GoogleCodeExporter commented 8 years ago 
Hello,

You are more than welcome to the code see the attached files (the example csv 
from Hargreaves Lansdown is already attached in a prior comment).

The necessary disclaimer to use this at your own peril, I am not a programmer 
so the code is not neat as I have cobbled it together from various google 
searches to accomplish what I wanted, although I have put notes in the code,  
if you can improve on the code please publish.

Some notes:-

The Excel Macros have been updated have been updated since the issue was opened 
and now performs 3 functions but, from your request you probably only need the 
first:-

1) changes the downloaded csv from Hargreaves Lansdown to the same format as 
that downloaded from FT.com and saves it as "hleOfx Import.csv"

2) changes the downloaded csv from Hargreaves Lansdown to the same format as 
that of the quoutes.csv that is produced by " 
hleOfxQuotes-Build_20110706_31-app" which is used by the Sunrriise project  " 
sunriise-Build_20110706_31-app " to directly update stock prices in .mny  and 
saves it as "QuotesImport.csv";  This is still experimental but looks like 
being a major feature.

3) runs batch files which runs " sunriise-Build_20110706_31-app" to import 
"QuotesImport.csv" into .mny and creates logs of the import.

The code presets the import Folder and save Folder locations but you can still 
browse to new locations from there or remove/update the presets in the code. 

None of this would have been possible without the outstanding work performed by 
the developer who has my heartfelt thanks.

Regards

Paul

Original comment by progers...@hotmail.com on 20 Jul 2011 at 8:07

Attachments:

GoogleCodeExporter commented 8 years ago 
I forgot to mention for the second function above:-

2) changes the downloaded csv from Hargreaves Lansdown to the same format as 
that of the quoutes.csv that is produced by " 
hleOfxQuotes-Build_20110706_31-app" which is used by the Sunrriise project  " 
sunriise-Build_20110706_31-app " to directly update stock prices in .mny  and 
saves it as "QuotesImport.csv";  

The prices I am downloading from Hargreaves Lansdown are All Fund prices which 
are not real time and are updated at midnight so are for the day before the 
date/time that is in the downloaded csv so I correct for this using:-

' Subtract one business day as Fund prices are previous working day
ActiveCell.Value = Application.WorksheetFunction.WorkDay(ActiveCell, -1)

Regards

Paul

Original comment by progers...@hotmail.com on 20 Jul 2011 at 8:26