Open GoogleCodeExporter opened 8 years ago
FT csv file
I have the same problem but mine wont import either stocks or funds
Original comment by udpr...@googlemail.com
on 11 Mar 2014 at 8:14
Attachments:
As a temporary solution one can copy the "Last Price Column" for stocks and the
"Net Asset Value" for funds from the downloaded csv file and paste into an old
results.csv file and import it.
One issue for fixing hleOfxQuotes I can see is that the FT no longer downloads
the "Currency of Last Price" for funds, but this can easily be got from the
last three characters of the Stock Exchange Symbol (for funds).
Original comment by pau...@gmail.com
on 11 Mar 2014 at 8:44
interesting as I'm not getting "net asset value" for funds " - look at my ft
file attached to my previous post
I've migrated to a new watchlist and is exporting from there, I think you are
exporting from portfolio
Original comment by udpr...@googlemail.com
on 11 Mar 2014 at 9:58
[deleted comment]
Yes, I'm downloading from my portfolio (not a watch list). But looks as though
you've got prices in your "Last Price" column for both shares and funds. I
guess you could copy that column data into an old results.csv as a temporary
solution.
Original comment by pau...@gmail.com
on 12 Mar 2014 at 6:33
I'm also seeing that UK equity prices are being imported at a value 100 times
greater than the actual price - ie a misplacement of the decimal point.
Euro and dollar values are imported correctly.
I've checked the quotes.csv file and it appears that hleOfxQuotes is producing
the incorrect value (ie the value in the source results file from FT looks to
be correct).
Original comment by davelaws...@gmail.com
on 12 Mar 2014 at 9:38
1) The incorrect (100x) £ issue is easily fixed: FT have changed the column
header from "Currency for Last Price" to "Currency OF Last Price". Change it
back and values are correct.
2) No fund values when downloading from Portfolio. FT need to fix this (and
chage 1) at the dame time, I hope)
Original comment by Kangeroo...@gmail.com
on 12 Mar 2014 at 4:41
Another issue to watch for with FT.com is the fact that there were 5 funds they
no longer had a price for (they did until the change). So they just deleted
them from my portfolio...!
Original comment by Kangeroo...@gmail.com
on 12 Mar 2014 at 4:45
sorry confused - are you saying change the column heading in the csv file
before passing it to this tool or are you saying change the view on FT website
, if so not sure which field to choose as I don't see either field as available
columns
Original comment by udpr...@googlemail.com
on 12 Mar 2014 at 6:39
Change the column heading in the csv file before passing it to the tool.
Original comment by davelaws...@gmail.com
on 12 Mar 2014 at 6:45
I have tried to change the data set shown by the FT download by creating a
custom view that shows only the data one needs, of course with the FT headings,
and thought that this might solve the issue if I then changed the headings in
the downloaded file. All the data in the viewable summary was right. However,
the data file downloaded was a mixture of the portfolio download and other data
not requested.
I also have had funds removed from my portfolio and cannot put them back as
they seem not to be in the FT data base although they were before the web site
change. An example is AXA Framlington American growth R Acc.
Original comment by woo...@hotmail.com
on 12 Mar 2014 at 8:12
[deleted comment]
we have managed to get it to work
- use portfolio
- edit current view
- for equities use
Last Price
Holding value (portfolio currency)
- for funds use
Last Price
Holding value (portfolio currency)
when you export the file it should contain both funds and equities
csv file should have the following headings
Name;Symbol: Exchange;Last Price;Currency of Last Price;Holding value
(portfolio currency);Currency of Holding value (portfolio currency)
as stated above rename 4 column from "Currency of Last Price" to "Currency for
Last Price"
and then it should work
Original comment by udpr...@googlemail.com
on 12 Mar 2014 at 9:37
Thanks to udpr I have also made it work- many thanks!
Is anyone else having the same problems as I am with funds. When first
introduced one of my funds that was previously listed disappeared Today 4 that
were listed yesterday are no longer supported today. I have complained to the
web site help line. More complaints would be helpful in resurrection the
previous service
Original comment by woo...@hotmail.com
on 13 Mar 2014 at 9:11
"We have received a feedback from our Technical group and they have advised
that the fund is not in our universe of funds. There are a number of reasons
why a fund may not appear in our universe of funds even though it previously
did. Ultimately it is the choice of the Fund as to whether they appear in our
Managed Fund service."
- FT Customer Services
Very helpful, I don't think....
Original comment by Kangeroo...@gmail.com
on 14 Mar 2014 at 9:06
I have some share prices, fund prices and the FTSE index to transfer into MM
from Ft.com. On the new Ft.com web site I had to migrate to a Watchlist because
in Portfolio view there was no value shown for the FTSE index. Now when I
export the Watchlist from FT.com and try to import it into hleOfxQuotes no
prices are transferred, no share prices, no fund prices and no FTSE index. Do I
need to wait for an update to hleOfxQuotes? Or is there a workaround which
works for shares, funds and the FTSE index?
Original comment by ian.trus...@gmail.com
on 14 Mar 2014 at 3:49
Ian
See comments above from udpr. It works. you need to download portfolio view but
edit that view and save before you send it to you results csv file. Then change
the words in the heading csv file in the way udpr suggests.
Original comment by woo...@hotmail.com
on 14 Mar 2014 at 4:58
I first tried using portfolio and edited the view and at least got share and
fund prices into hleOfxQuotes but but it did not show the FTSE index. Now I
have migrated to a Watchlist where the view can not be edited and I can again
see the FTSE index but I don't even know how to go back to the portfolio view
where the view can be edited. Not sure what to do other than wait for a new
version of hleOfxQuotes.
Original comment by ian.trus...@gmail.com
on 14 Mar 2014 at 6:31
Since my previous post I laboriously recreated my portfolio and did the view
editing and rewording of the header in the .csv file and yes it does work for
me for shares and funds, leaving just the FTSE index price to update in MM
manually. I hope the program will be updated to work properly with the changed
ft.com site. Is that likely to happen soon?
Original comment by ian.trus...@gmail.com
on 14 Mar 2014 at 7:32
Thanks udpr. Got it to work using your process above.
Original comment by jesha...@gmail.com
on 18 Mar 2014 at 11:38
Also, thanks to udpr. Likewise download now working
Original comment by mijo...@googlemail.com
on 18 Mar 2014 at 5:40
I've contacted FT.COM re the absence of fund prices.
They've provided me with a solution which I've tested and works fine for me.
The email exchange is copied below:
Dear xxxx,
Thank you for your email.
While this is the latest layout, the company is actively working to improve
service levels. As an alternative, this can be corrected by selecting 'Last
Price' for funds as well. You just need to click 'edit current' button then go
to ETF tab then add Last Price. With this fund prices are then downloaded to
CSV.
We have forwarded your feedback to our development team. We greatly value your
comments and your support as these make us continue to provide the best service
to our customers. Please continue to send us any feedback that you may have
with regard to our products.
Thank you for your time and please feel free to contact us should you have
further queries.
Kind regards,
Rusella Canio
Customer Service Executive
Financial Times Customer Service - FT.com
Email: help@ft.com
International Toll Free: +800 0705 6477
UK & CEMEA: +44 20 7775 6248
US & Canada: +1 917 551 5005 or +1 855 685 2372 (Toll Free) Asia Pacific: +632
982 5780
Japan: 0120 341 468
India: 000 800 001 6817 (Toll Free)
--------------- Original Message ---------------
From: xxxx
Sent: 19/03/2014 02:02
To: help@ft.com
Subject: FW: Case Number 1185285: Recent updates to Portfolio service [
ref:_00D20LryV._500D0aokiB:ref ]
Thank you for your reply.
I'm puzzled by the explanation given as the fund values were provided before
the update to the portfolio service.
Attached are two files. The one named "results.csv" was produced by the ft
site before the update, the other file was produced after the update. As you
can see, the value information is present in the earlier file but not the newer
one.
Regards
xxxx
-----Original Message-----
From: noreply@salesforce.com [mailto:noreply@salesforce.com] On Behalf Of FT
Customer Service
Sent: 18 March 2014 01:51
To: xxxx
Subject: Case Number 1185285: Recent updates to Portfolio service [
ref:_00D20LryV._500D0aokiB:ref ]
Dear xxxx,
Thank you for contacting Financial Times Customer Service.
As per our market data team, the cvs data is showing "n/a" for funds because
the Last Price is not applicable to managed funds. We are displaying the net
asset value for this type of security. Similarly since the net asset value does
not apply to equities, the equity row will have "n/a" under the Net Asset Value
column.
I hope this helps. For any other concerns, please feel free to email or
contact us and we'll be glad to assist you.
Kind regards,
Rusella Canio
Customer Service Executive
Financial Times Customer Service - FT.com
Email: help@ft.com
International Toll Free: +800 0705 6477
UK & CEMEA: +44 20 7775 6248
US & Canada: +1 917 551 5005 or +1 855 685 2372 (Toll Free) Asia Pacific:
+632 982 5780
Japan: 0120 341 468
India: 000 800 001 6817 (Toll Free)
--------------- Original Message ---------------
From: xxxx
Sent: 18/03/2014 03:54
To: help@ft.com
Subject: Recent updates to Portfolio service
Following the recent updates to this service I can no longer have fund prices
exported from my Portfolio.
ie From my "Portfolio" page, I click the heading "Export data" and select
"Holdings" from the EXPORT DATA pop-up menu.
When I examine the downloaded data file, I find that equity prices are
populated but fund prices are not.
Prior to the update to the Portfolio service, both equities and fund prices
were populated.
Is this a known problem?
Regards
Original comment by davelaws...@gmail.com
on 20 Mar 2014 at 1:46
Hi lawsonu
I got the same initial response from the same person at the FT. I sent them the
solution on the 19th, which they passed on to you, it seems.
I remain amazed that FT don't understand fund prices and nav.
I tried to get them to change the currency heading back to what it was but no
reply. Maybe you could ask too?
Original comment by Kangeroo...@gmail.com
on 23 Mar 2014 at 8:47
There is a fundamental problem with the values for funds as the FT file does
not have the information as to the them at all and some are in GBP (pounds) and
some in GBX (pence).
Original comment by i...@cyberprescotts.com
on 24 Mar 2014 at 1:50
Please read the above thread which addresses this issue
Original comment by Kangeroo...@gmail.com
on 24 Mar 2014 at 7:58
Thanks Kangeroo. There was a typing error in my post which made it unclear
what I meant. Apologies. The Values for funds are in the FT file (under "Net
Asset Value") but not the currency of them. FT values most of my funds in GBP
(pounds) but a few it values in GBX (pence). However, "Currency of Last price"
just says "n/a" for all funds and none of the other data indicates whether the
"Net Asset Value" is in GBP or GBX.
Original comment by i...@cyberprescotts.com
on 25 Mar 2014 at 12:11
".this can be corrected by selecting 'Last Price' for funds as well. You just
need to click 'edit current' button then go to ETF tab then add Last Price.
With this fund prices are then downloaded to CSV."
That gives you the fund prices in the correct column, as we'll as the currency.
Original comment by Kangeroo...@gmail.com
on 25 Mar 2014 at 3:07
Since FT changed the portfolio tool I have the same problem as #6 lawsonu...
above (share prices in GBX instead of GBP, so showing as x100). I tried the fix
described in #7 Kangeroo but get x100 and x100 again, 1.e. 10,000 x true price
in GBP, showing in the tool. Also seven out of 28 shares in the portfolio have
" inserted which displaces the fields in the row one column to the right.
Together these issues make the new FT download practically unusable for me. I'm
waiting a response from FT support. Meantime has anyone any ideas for how to
restore some order?! (Desktop with Windows 7 Pro - everything worked fine until
the FT's latest "improvements".)
Original comment by johnmcin...@dsl.pipex.com
on 1 Apr 2014 at 1:07
Odd. Once you have imported the downloaded .CSV file, the tool should show the
downloaded price value followed by GBP or GBX to tell Money if it is in pounds
or pence. Worth checking what your seeing there.
Original comment by Kangeroo...@gmail.com
on 1 Apr 2014 at 7:29
My remaining inconvenience following the FT Portfolio change is the requirement
to edit the .csv file downloaded from the FT Portfolio to change the header
from "Currency of Last Price" to "Currency for Last Price".
Is it possible that the hleOfxQuotes program could be updated to accommodate
this change automatically or has support for the hleOfxQuotes program stopped?
I hope not.
Original comment by ian.trus...@gmail.com
on 11 Apr 2014 at 1:52
re comment#30 same issue with me.The x100 price problem is solved by manually
changing the csv downloaded file column heading to "for" instead of "of".But
this must be done every time you download new prices.Anyone solved that
problem??Also have not found a way to download updated fx rates except ofourse
manually in the microsoft mm pp.Any solutions out there.
Original comment by ronwok...@gmail.com
on 29 Apr 2014 at 8:45
my hleofx mapper buton does not bring up the mapper.I know the mapper file is
working ok as the prices updates for stocks and funds works ok,but it will ot
show up on the hle...ofx app.Any clues
Original comment by ronwok...@gmail.com
on 29 Apr 2014 at 8:49
Original issue reported on code.google.com by
woo...@hotmail.com
on 11 Mar 2014 at 5:16