bornerways
New Member
- Joined
- Mar 12, 2021
- Messages
- 2
- Office Version
- 2007
- Platform
- Windows
I'm an 84 year old 'user' of MS Office 2007, Excel on a Windows 10 platform.
I' normally use VLOOKUP to calculate transactions and values based on the Stock Exchange quoted unit prices for Funds & Shares as published by the FT. These are in a vertical table against a calendar (all dates in a year). Stock Exchanges, wherever, do not normally operate at weekends, bank and other holidays but these vary across the world, so the l table show blanks, sometimes for4 or more days. Transactions, as well, can occur on any of these days so the unit value for the next trading day needs to be used. How, therefore can I look up the NEXT available 'Unit Value' from the tables. Even "Days of the Week" cannot be used as a limiter as Sat becomes a weekday in countries where Friday is their sabbath. A series of nesting fomulae would be difficult to construct & very lengthy,
I can't find a formula that selects the 'NEXT' value or limiter within the MS Excel portfolio which surprises me.
Hope someone can point me towards an easy solution.
Regards
Bornerways
I' normally use VLOOKUP to calculate transactions and values based on the Stock Exchange quoted unit prices for Funds & Shares as published by the FT. These are in a vertical table against a calendar (all dates in a year). Stock Exchanges, wherever, do not normally operate at weekends, bank and other holidays but these vary across the world, so the l table show blanks, sometimes for4 or more days. Transactions, as well, can occur on any of these days so the unit value for the next trading day needs to be used. How, therefore can I look up the NEXT available 'Unit Value' from the tables. Even "Days of the Week" cannot be used as a limiter as Sat becomes a weekday in countries where Friday is their sabbath. A series of nesting fomulae would be difficult to construct & very lengthy,
I can't find a formula that selects the 'NEXT' value or limiter within the MS Excel portfolio which surprises me.
Hope someone can point me towards an easy solution.
Regards
Bornerways