Remove ads

Introducing the LemonFools Personal Finance Calculators

HYPTUSS problem with 888 Holdings

Discussions regarding financial software
GN100
Lemon Pip
Posts: 97
Joined: November 4th, 2016, 10:14 am
Has thanked: 8 times
Been thanked: 7 times

HYPTUSS problem with 888 Holdings

#104645

Postby GN100 » December 17th, 2017, 8:03 am

I have just added 888 Holdings to the last line on my HYPTUSS v 11.4 running Excel 2007 on Win 10 Pro. The Comany name column on the Portfolio sheet appears as N/A, the ticker appears correctly as 888 but has a green triangle in the top left corner of the cell, which I believe means the cell contains a formula that is different to its neighbour, columns H & I appear correctly. J,K & L appear blank and won't update when I run the DL update yields button giving the runtime error box. All the tickers abbove 888 on my sheet up date correctly. Current Price updates correctly. The Open DL site button works correctly. I have checked the DL Data tab for 888 and that all appears correct.

I can enter the DL data manually. Any Ideas?

Raptor
Lemon Quarter
Posts: 1520
Joined: November 4th, 2016, 1:39 pm
Has thanked: 108 times
Been thanked: 239 times

Re: HYPTUSS problem with 888 Holdings

#104660

Postby Raptor » December 17th, 2017, 9:37 am

The formula isn't working with "888". Changing the EPIC in the data sheets and it picks up the corrct details. Have not time at moment but will dive a bit deeper later. Anyone with VLOOKUP experience who may know the reason?

Raptor.

kiloran
Lemon Quarter
Posts: 1419
Joined: November 4th, 2016, 9:24 am
Has thanked: 263 times
Been thanked: 578 times

Re: HYPTUSS problem with 888 Holdings

#104678

Postby kiloran » December 17th, 2017, 10:22 am

I just checked and the problem appears to be that column C in the "Digital Look Data Sheet" is formatted as General, so the 888 in cell C4 is being interpreted as a number, which screws up the VLOOKUP

Solutions are:
  1. Change Cell C4 from 888 to '888 ... this will make the cell appear as text
    or
  2. Select column C in the "Digital Look Data Sheet", right-click and format as text. Then overtype Cell C4 with 888 to force it to text

We'll look for a cleaner solution for future releases, either by adding this issue to our checklist to ensure that column C is text when published, or by modifying the VLOOKUP

--kiloran

GN100
Lemon Pip
Posts: 97
Joined: November 4th, 2016, 10:14 am
Has thanked: 8 times
Been thanked: 7 times

Re: HYPTUSS problem with 888 Holdings

#104681

Postby GN100 » December 17th, 2017, 11:14 am

Thanks for the rapid response and solution. 1) works for me. I changed the ticker in the Digital Look data sheet to'888 and everything works fine. Spreadsheets now all nice and tidy, ready for Monday morning.

GN


Return to “Financial Software - Discussion”

Who is online

Users browsing this forum: No registered users and 2 guests