Donate to Remove ads

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

Thanks to johnstevens77,Bhoddhisatva,scotia,Anonymous,Cornytiv34, for Donating to support the site

HYPTUSS circular references

Discussions regarding financial software
staffordian
Lemon Quarter
Posts: 2298
Joined: November 4th, 2016, 4:20 pm
Has thanked: 1887 times
Been thanked: 869 times

HYPTUSS circular references

#309772

Postby staffordian » May 18th, 2020, 10:11 pm

On one or two occasions, including today, I've opened the HYPTUSS (11.72, the latest version), clicked the button to get prices, and an Excel warning box has popped up in front of the spreadsheet saying that there are circular references.

Opening the Excel Error Checking for circular references takes me to a cell in the Company data sheet, and I see that in some (but not all) of the lines relating to shares I hold, the entry in column D, the New Data Sheet Sector has changed from a sector description to a formula, such as:

=VLOOKUP(TEXT(C65,"0"),'Company Data Sheet'!C:D, 2,FALSE)

and the display in the cell is a 0.

Does this behaviour suggest an issue I can or should do anything about?

As far as I can tell, in spite of this warning, everything is working as I would expect.

I'm running Windows 10 and Excel 2007 (yes, I know, but I'm a cheapskate :D )

TIA

Staffordian

EDIT: Just discovered that when I click the Get Sharecast Forecast Yields button, all but the first entry comes back (quite quickly) as 0.00%

monabri
Lemon Half
Posts: 8396
Joined: January 7th, 2017, 9:56 am
Has thanked: 1539 times
Been thanked: 3428 times

Re: HYPTUSS circular references

#309784

Postby monabri » May 18th, 2020, 11:22 pm

Possibly a formatting issue on the cell in question? The format has accidentally been changed.

Perhaps similar to the issue I had.

viewtopic.php?p=226734#p226734

staffordian
Lemon Quarter
Posts: 2298
Joined: November 4th, 2016, 4:20 pm
Has thanked: 1887 times
Been thanked: 869 times

Re: HYPTUSS circular references

#309788

Postby staffordian » May 18th, 2020, 11:51 pm

monabri wrote:Possibly a formatting issue on the cell in question? The format has accidentally been changed.

Perhaps similar to the issue I had.

viewtopic.php?p=226734#p226734


Thanks monabri. I'll investigate tomorrow and see if my issue is similar.

staffordian
Lemon Quarter
Posts: 2298
Joined: November 4th, 2016, 4:20 pm
Has thanked: 1887 times
Been thanked: 869 times

Re: HYPTUSS circular references

#310084

Postby staffordian » May 19th, 2020, 9:25 pm

monabri wrote:Possibly a formatting issue on the cell in question? The format has accidentally been changed.

Perhaps similar to the issue I had.

viewtopic.php?p=226734#p226734


Just to wrap this up, the formatting was correct, so no joy there, but I did what I should have done in the first place; I downloaded a new version of the HYPTUSS and copied my data over.

This seems to have resolved the problem, so it must have been something I did inadvertently to my copy.

Thanks for your suggestion though - much appreciated.

Staffordian

kiloran
Lemon Quarter
Posts: 4092
Joined: November 4th, 2016, 9:24 am
Has thanked: 3234 times
Been thanked: 2827 times

Re: HYPTUSS circular references

#310091

Postby kiloran » May 19th, 2020, 9:39 pm

staffordian wrote:
monabri wrote:Possibly a formatting issue on the cell in question? The format has accidentally been changed.

Perhaps similar to the issue I had.

viewtopic.php?p=226734#p226734


Just to wrap this up, the formatting was correct, so no joy there, but I did what I should have done in the first place; I downloaded a new version of the HYPTUSS and copied my data over.

This seems to have resolved the problem, so it must have been something I did inadvertently to my copy.

Thanks for your suggestion though - much appreciated.

Staffordian

That's good news, I was just about to have a look at this. I've got no idea what could have caused the problem, let's hope it wasn't Covid-19, I don't think my antivirus protects against that!

--kiloran


Return to “Financial Software - Discussion”

Who is online

Users browsing this forum: No registered users and 4 guests