Donate to Remove ads

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

Thanks to eyeball08,Wondergirly,bofh,johnstevens77,Bhoddhisatva, for Donating to support the site

How to update HYPTUSS data sheet

Discussions regarding financial software
NorwichFool
Posts: 16
Joined: December 15th, 2016, 10:32 am
Has thanked: 15 times
Been thanked: 6 times

How to update HYPTUSS data sheet

#199000

Postby NorwichFool » February 5th, 2019, 9:31 am

How do I update the data sheet on HYPTUSS

I have downloaded the most recent version of the data sheet and it is now in my "Downloads" folder.
My HYPTUSS is on my desktop. How do I get the new data sheet into my HYPTUSS spreadsheet.

Sorry if this is a stupid question, but I can't work it out.

Thanks, norwichfool

EssDeeAitch
Lemon Slice
Posts: 655
Joined: August 31st, 2018, 9:08 pm
Has thanked: 268 times
Been thanked: 251 times

Re: How to update HYPTUSS data sheet

#199016

Postby EssDeeAitch » February 5th, 2019, 10:20 am

NorwichFool wrote:How do I update the data sheet on HYPTUSS

I have downloaded the most recent version of the data sheet and it is now in my "Downloads" folder.
My HYPTUSS is on my desktop. How do I get the new data sheet into my HYPTUSS spreadsheet.

Sorry if this is a stupid question, but I can't work it out.

Thanks, norwichfool


I open the new file, copy the contents of the Digital Look Data Sheet (click in any cell, then control + a) then paste in over the existing Data Sheet (careful to select cell A1 before pasting - control +v)

Hope this helps

kiloran
Lemon Quarter
Posts: 4108
Joined: November 4th, 2016, 9:24 am
Has thanked: 3242 times
Been thanked: 2844 times

Re: How to update HYPTUSS data sheet

#199019

Postby kiloran » February 5th, 2019, 10:32 am

EssDeeAitch wrote:
NorwichFool wrote:How do I update the data sheet on HYPTUSS

I have downloaded the most recent version of the data sheet and it is now in my "Downloads" folder.
My HYPTUSS is on my desktop. How do I get the new data sheet into my HYPTUSS spreadsheet.

Sorry if this is a stupid question, but I can't work it out.

Thanks, norwichfool


I open the new file, copy the contents of the Digital Look Data Sheet (click in any cell, then control + a) then paste in over the existing Data Sheet (careful to select cell A1 before pasting - control +v)

Hope this helps

After the CTRL+A, you need a CTRL+C to copy to the clipboard. There is also a danger that perhaps the new version has fewer rows than the original, so I would suggest:
  1. If you are not 100% comfortable with these operations in Excel or LibreOffice, first make a copy of your HYPTUSS in case you corrupt the HYPTUSS
  2. Open HYPTUSS, then select the Digital Look Data Sheet
  3. CTRL+A to select all cells, then hit the Delete key
  4. In Excel (or LibreOffice), FILE/OPEN and select the new file digital_look_data_sheet.txt
  5. In the new sheet, CTRL+A then CTRL+C to copy all cells to the clipboard
  6. Select cell A1 in the HYPTUSS Digital Look Data Sheet, then CTRL+V to paste the data
  7. The file digital_look_data_sheet.txt can then be discarded.

--kiloran

EssDeeAitch
Lemon Slice
Posts: 655
Joined: August 31st, 2018, 9:08 pm
Has thanked: 268 times
Been thanked: 251 times

Re: How to update HYPTUSS data sheet

#199025

Postby EssDeeAitch » February 5th, 2019, 10:52 am

Ah, thanks for the correction kiloran, I knew that of course just forgot to put it in the post.

kempiejon
Lemon Quarter
Posts: 3553
Joined: November 5th, 2016, 10:30 am
Has thanked: 1 time
Been thanked: 1172 times

Re: How to update HYPTUSS data sheet

#199035

Postby kempiejon » February 5th, 2019, 11:23 am

I'm sure those of us who have added a few more exotics to the end of the datasheet know to copy those extras and append them when the updated sheet has been pasted.
I too think it is good practice to make a copy of your current HYP to try any changes on so there is a working earlier example to revert back to if you make a mistake.

robbelg
Lemon Slice
Posts: 407
Joined: November 4th, 2016, 10:43 am
Has thanked: 185 times
Been thanked: 155 times

Re: How to update HYPTUSS data sheet

#199038

Postby robbelg » February 5th, 2019, 11:30 am

Before you test it take note of the current Webfg problems as in this thread:

viewtopic.php?f=27&t=16060

Rob

NorwichFool
Posts: 16
Joined: December 15th, 2016, 10:32 am
Has thanked: 15 times
Been thanked: 6 times

Re: How to update HYPTUSS data sheet

#199049

Postby NorwichFool » February 5th, 2019, 12:30 pm

Many thanks for replies. All done now. Shame Webfg is playing up today.


Return to “Financial Software - Discussion”

Who is online

Users browsing this forum: No registered users and 26 guests