Or am I just going blind in my old age.
It's well in the FTSE-250
Is AA plc missing from the HYPTUS list?
-
- Lemon Slice
- Posts: 755
- Joined: November 4th, 2016, 4:27 pm
-
- Lemon Quarter
- Posts: 3865
- Joined: November 4th, 2016, 9:24 am
Re: Is AA plc missing from the HYPTUS list?
You're right!NeilW wrote:Or am I just going blind in my old age.
It's well in the FTSE-250
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
-
- Lemon Quarter
- Posts: 3865
- Joined: November 4th, 2016, 9:24 am
Re: Is AA plc missing from the HYPTUS list?
MNL works fine for me.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!
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