HYPTUSS - a new tic

[Arborbridge]

My v11-85 ran OK on Saturday, but has developed an oddity: on the FTSE-HYP tracking sheet, the latest "run" over-writes the final row rather than adding one row on.

Has anyone else noticed this?

Any ideas on how this can have happened, or how to correct it (bearing in mind I'm totally Excel "programming" ignorant).

Thanks,


Arb.

[seagles]

There is a fix viewtopic.php?p=682356#p682356
I think that is the right link.

[Arborbridge]

There is a fix viewtopic.php?p=682356#p682356
I think that is the right link.

Thanks for that. Oddly, I've been runningv11-85 until this weekend without that problem showing up - yet I note it was talked about in September!

[Arborbridge]

There is a fix viewtopic.php?p=682356#p682356
I think that is the right link.

The problem being that v11-88 doesn't download prices - which is why I use v11-85.

Can anyone guide me as to how to access this code in the link above and make the change needed?

Thanks.

[seagles]

1. Open spreadsheet.
2. Click on Developer
3. Click on Visual Basic
4. Click on VBAProject, this will open a password box
5. Enter pleaseletmein
6. Click on Microsoft Excel Objects
7. Double Click on sheet1
8. Scroll down to end of object to get to getindex
9. Meanwhile copy
If cleanString(hrow.Cells(0).innerText) = index Then
'Debug.Print hrow.Cells(0).innerText, hrow.Cells(1).innerText
indexValue = cleanString(hrow.Cells(1).innerText)
End If
10. Replace
If hrow.Cells(0).innerText = index Then
'Debug.Print hrow.Cells(0).innerText, hrow.Cells(1).innerText
indexValue = hrow.Cells(1).innerText
End If

with copied code.

I have provided a workaround

So using "get yields" or "get prices" is currently overiding the last entry in the tracking tab. My workaround is to add figures to the first 2 columns, then it will add a "new" line next time you use either of the two "buttons".

[seagles]

BTW I believe the reason your 11.85 is working is that it has the parameter for getting prices set to shareprice rather than yahoo. If you change this on 11.88 it will also work as it grabs data from shareprice.