Donate to Remove ads

Got a credit card? use our Credit Card & Finance Calculators

Thanks to Anonymous,bruncher,niord,gvonge,Shelford, for Donating to support the site

Is AA plc missing from the HYPTUS list?

Discussions regarding financial software
NeilW
Lemon Slice
Posts: 766
Joined: November 4th, 2016, 4:27 pm
Has thanked: 149 times
Been thanked: 237 times

Is AA plc missing from the HYPTUS list?

#57291

Postby NeilW » June 2nd, 2017, 11:30 am

Or am I just going blind in my old age.

It's well in the FTSE-250

kiloran
Lemon Quarter
Posts: 4137
Joined: November 4th, 2016, 9:24 am
Has thanked: 3293 times
Been thanked: 2871 times

Re: Is AA plc missing from the HYPTUS list?

#57299

Postby kiloran » June 2nd, 2017, 11:46 am

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

kiloran
Lemon Quarter
Posts: 4137
Joined: November 4th, 2016, 9:24 am
Has thanked: 3293 times
Been thanked: 2871 times

Re: Is AA plc missing from the HYPTUS list?

#57326

Postby kiloran » June 2nd, 2017, 12:58 pm

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


Return to “Financial Software - Discussion”

Who is online

Users browsing this forum: No registered users and 17 guests