Page 1 of 1
Is AA plc missing from the HYPTUS list?
Posted: June 2nd, 2017, 11:30 am
by NeilW
Or am I just going blind in my old age.
It's well in the FTSE-250
Re: Is AA plc missing from the HYPTUS list?
Posted: June 2nd, 2017, 11:46 am
by kiloran
NeilW wrote:Or am I just going blind in my old age.
It's well in the FTSE-250
You're right!
I've uploaded an updated version of digital_look_data_sheet.txt at
http://lemonfoolfinancialsoftware.weebl ... op-up.html which you can import into your HYPTUSS
It will be incorporated in future releases of HYPTUSS
--kiloran
Re: Is AA plc missing from the HYPTUS list?
Posted: June 2nd, 2017, 12:58 pm
by kiloran
ap8889 wrote:Hi kiloran, I encounter an error when adding Manchester and London IT to the Digitallook data sheet: despite filling in the name and sector columns with the data as per the FAQ on the Weebly site I end up with no name or sector for the IT in the main sheet itself. The Ticker is ok, I do pick up the price though, so at least that is working ok!
MNL works fine for me.
I've updated digital_look_data_sheet.txt at
http://lemonfoolfinancialsoftware.weebl ... op-up.html with the correct data.
Assuming you are using the Excel version (it really does help us if you tell us what version you are using), what do you see in the cells for the name and sector?
You should see something like
=INDEX('Digital Look Data Sheet'!B:B,MATCH(TEXT(C6,"0"),'Digital Look Data Sheet'!C:C,0))
in the name cell and
=VLOOKUP(TEXT(C6,"0"),'Digital Look Data Sheet'!C:D, 2,FALSE)
in the sector cell
--kiloran