SI
SI
discoversearch

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor.  We ask that you disable ad blocking while on Silicon Investor in the best interests of our community.  If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.
Biotech / Medical : 2022 Biotech Charity Contest
 Public ReplyPrvt ReplyMark as Last ReadFilePrevious 10Next 10PreviousNext  
To: technetium who wrote (48)1/4/2022 10:15:07 PM
From: technetium  Read Replies (1) of 267
 
Here is everything that you need to follow things along. Remember that there may be some rounding in the displayed numbers, but all values are input as provided by Yahoo Finance, and calculations are done to the full precision of the spreadsheet (12 digits or so if I recall correctly). Both the setup data (Dec 31, 2021 or Dec 30 for European exchanges), and the values as of 8 pm EST Jan 4 are given.

Note: Given that I may not download the stock prices and the foreign currency exchange rate at precisely 4 PM EST time every Friday, and the I think that exchange rates are updated hourly, there may be fluctuations in the price I assign to stocks traded on foreign markets depending on the precise time that I download the exchange rates. Thus far the difference has been negligible.
The exchange rate used for foreign exchange share purchases:

Currency Symbol

Value

AUDUSD=X

0.7272198

CADUSD=X

0.7905138

CHFUSD=X

1.0964552

EURUSD=X

1.1379154

GBPUSD=X

1.3530885

HKDUSD=X

0.1282719

NOKUSD=X

0.113

SEKUSD=X

0.110604174
Report TOU ViolationShare This Post
 Public ReplyPrvt ReplyMark as Last ReadFilePrevious 10Next 10PreviousNext  

HomeMailHotSubjectMarksPeopleMarksKeepersSettings
Terms Of UseContact UsCopyright/IP PolicyPrivacy PolicyAbout UsFAQAdvertise on SI
© 2026 Knight Sac Media.  Data provided by Twelve Data, Alpha Vantage, and CityFALCON News