New FT web site 11/03/2014 problem

[GoogleCodeExporter]

What steps will reproduce the problem?
1. larger results file downloads which includes new columns contains stocks and 
fund data
2. import csv now only imports stock prices but not fund prices
3. mapper downloads correctly

What is the expected output? What do you see instead?
Stock prices and no fund prices

What version of the product are you using? On what operating system?
Current version

Please provide any additional information below.
The program worked yesterday using the old FT web site

Original issue reported on code.google.com by woo...@hotmail.com on 11 Mar 2014 at 5:16

[GoogleCodeExporter]

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:

• douglas_2014-03-11_0542PM.csv

[GoogleCodeExporter]

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

[GoogleCodeExporter]

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

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

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

[GoogleCodeExporter]

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

[GoogleCodeExporter]

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

[GoogleCodeExporter]

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

[GoogleCodeExporter]

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

[GoogleCodeExporter]

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

[GoogleCodeExporter]

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

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

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

[GoogleCodeExporter]

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

[GoogleCodeExporter]

"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

[GoogleCodeExporter]

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

[GoogleCodeExporter]

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

[GoogleCodeExporter]

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

[GoogleCodeExporter]

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

[GoogleCodeExporter]

Thanks udpr. Got it to work using your process above. 

Original comment by jesha...@gmail.com on 18 Mar 2014 at 11:38

[GoogleCodeExporter]

Also, thanks to udpr. Likewise download now working

Original comment by mijo...@googlemail.com on 18 Mar 2014 at 5:40

[GoogleCodeExporter]

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

[GoogleCodeExporter]

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

[GoogleCodeExporter]

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

[GoogleCodeExporter]

Please read the above thread which addresses this issue

Original comment by Kangeroo...@gmail.com on 24 Mar 2014 at 7:58

[GoogleCodeExporter]

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

[GoogleCodeExporter]

".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

[GoogleCodeExporter]

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

[GoogleCodeExporter]

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

[GoogleCodeExporter]

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

[GoogleCodeExporter]

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

[GoogleCodeExporter]

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