• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

EVP Systems

  • Home
  • Support
    • Contact
    • FAQs
    • Tutorials
  • Software
  • Services
  • Accounts
    • Sign-Up
    • Mailing Lists
    • Pricing
    • Payments
  • About Us
    • The Company
    • EVP Office
    • Professional Services
    • EVP Everywhere
    • EVP Upload
    • Legal and Compliance
    • Sales Material
    • Contact Us

EstateVal 8.2 Offers Paste-From-Excel and Find

The goal of EstateVal 8.2 was to make entering data into it faster, easier and more accurate, by focusing on the user-interface for the first time in years. This is the first article of three about these new features, covering Paste-from-Excel and Find.

Paste from Excel

For literally decades, EstateVal has had the ability to import a list of CUSIPs and shares from Excel. But exporting the CSV (comma-separated value) file from Excel and then loading it into EstateVal could be a tedious process.

So we’re happy to introduce paste-from-Excel! Now, if you have a column of CUSIPs in Excel, you can simply highlight them there, copy them to the clipboard, and then paste them into EstateVal, just like it was another spreadsheet. If you copy two columns, EstateVal will put the second column into its Shares/Par column.

You can even grab CSV values from a text editor and paste them into the grid. If you have data that looks like this:

IBM,100
MSFT,250
AAPL,50

…then copy-and-paste works just like it does from Excel.

It’s an incredibly handy feature that is both more intuitive and more flexible than the CSV file import. You can copy hundreds of CUSIPs and shares from Excel and paste directly them into EstateVal in seconds.

Find

Speaking of hundreds of CUSIPs, EstateVal allows you to enter up to five hundred CUSIPs into a portfolio by default — but that number is arbitrary and can be changed, up to 9,999! Either way, that’s a lot of CUSIPs! So what if you have a giant portfolio, and need to find a specific security in that very long list? Before EstateVal 8.2, you’d start at the top and carefully scroll down until you happened to stumble across it. Miss it? Start over.

But that’s silly. Word processors, spreadsheets — every program imaginable — has had search for decades. Why not EstateVal? Finally, it does.

Clicking Tools > Find… or pressing Ctrl+F will bring up the new Find dialog. Type in a search — either the identifier you’ve entered into EstateVal, or the name of the security if you’ve run an evaluation — and press “Find.” A status line in the dialog will show you the first lot that matches and the grid will jump to that lot, highlighting it. Click “Find” again, and it will search for the next match in your list. Keep clicking and eventually it will wrap around to the first again. If you’re looking for a single CUSIP in a list of 500, this can be an enormous time-saver.

You can also drop down a list of other ways to search in the Find dialog: Unpriced lots, user-priced lots, old-priced lots or failed-to-price lots, for either the Date of Death report, the Alternate Date report, or both. (An unpriced lot is one that hasn’t been evaluated yet; user-priced are items that use the “User-Defined Information” section of the lot inventory dialog; old-priced lots have been evaluated and have a price, but the price is older than evaluation date; failed-to-price lots are items that EstateVal could not find a price for.) If you’ve got a big portfolio and want to find that one security that has been manually priced, or that didn’t price, these selections make the process quick and efficient.

Next Time…

These are only two of the great new features that EstateVal 8.2 has. Come back soon for more!

Posted on March 7, 2018 • Tagged with EVP Office, Release

Primary Sidebar

Things You Should Know

  • Good to Know: Reports on April 9, 2025
  • Happy Holidays from EVP Systems! on December 9, 2024
  • Fee Changes for 2025 on November 1, 2024
  • We're Going to Disneyland---for NAEPC 2024! on October 18, 2024
  • CrowdStrike BSOD and EVP Systems
  • EVP Office 9.1.3 Now Available on July 18, 2024
  • EVP Office 9.1.0: Now Available, Featuring Name Preview on January 8, 2024
  • EVP Systems at Heckerling 2024 on January 3, 2024
  • Happy Holidays from EVP Systems! on December 11, 2023
  • EVP Systems at the California Probate Referees Conference on November 30, 2023
  • Join us at NAEPC 2023 on November 11, 2023
  • Good to Know: The Grid on August 23, 2023
  • Announcing Fee Changes for 2023 on October 7, 2022
  • "Single Broker Quotes" Available Again on April 14, 2022
  • EVP Systems Prepared for Russia / Ukraine Conflict on March 14, 2022
  • Expat and Open Source at EVP Systems on March 1, 2022
  • EVP Office 9.0.1 Offers Built-In Calculator, More Crypto, New Export on February 8, 2022
  • Jack Barthel, 1937 - 2021 on January 19, 2022
  • EVP Systems Unaffected by log4shell and Associated Vulnerabilities on December 13, 2021
  • EVP Office 9: Something Big! on October 13, 2021
  • EVP Office 8.5.3: Secure by Default on July 13, 2021
  • Ready for Windows 11 on July 2, 2021
  • EVP Office 8.5.2: Native Excel Export, Better Copy-and-Paste, Mailing Lists on April 8, 2021
  • A Lockdown Check-In on October 5, 2020
  • Upgrade Your Invoice on September 21, 2020
  • EVP Systems Introduces Modern, Streamlined Website on August 13, 2020
  • EVP Office 8.5.0 Released on June 17, 2020
  • EVP Systems Continues to Support Retired Versions of Windows on December 4, 2019
  • EstateVal 8.4.0 Prices Foreign Currencies, Precious Metals on October 25, 2019
  • GEMS Adds EVP Everywhere for Faster, Easier Pricing on April 15, 2019
  • EVP Office 8.3.1 Now Available; Features Easy Pricing of Puts and Calls on March 15, 2019
  • Reminder: Fee Changes Coming in 2019 on December 28, 2018
  • TEdec Adds Built-In Evaluations, with EVP Everywhere on December 3, 2018
  • Primary and Composite Exchange Pricing in EstateVal
  • A Brief Introduction to EstateVal

Don’t let death and taxes ruin your day!

Footer

About EVP Systems

Trusted by thousands of banks, brokerages, and law firms, Estate Valuations & Pricing Systems has been the leading provider of high-quality security evaluations for estate- and gift-tax purposes for over 40 years.

Get in Touch

1531 Chapala St., #1
Santa Barbara, CA 93101
(818) 313-6300 • FAX: (818) 313-6313
support@evpsys.com
sales@evpsys.com
Twitter
Mailing Lists

Explore the Site

Installation Pricing Open Source Payment CostBasis

All contents copyright © 1984–2025 Estate Valuations & Pricing Systems, Inc. • Do Not Sell My Personal Information • Service Status