Is it possible to import MS Excel Tables to Opto Numeric Tables?

If direct importation is not possible, are there any other ways to import tables?

Hi innotech01,

There are a couple of different ways you could take your table data from Excel and put it into a numeric table. The method you choose will depend on a couple of things:

  1. Is this a one-shot deal, where you're initializing some values perhaps as your strategy gets running? If so, check out this post about initializing tables:
  2. Are you using PAC Display, and have you considered using recipes? Here's a webinar that shows how/when to use those:
  3. If you save that spreadsheet as a text file, like a CSV (comma delimited), you could then have your strategy read and parse that file and load the values into a Numeric Table variable in your strategy. It's pretty easy to move a file from a PC to a PAC using FTP. Of course, if you're using SoftPAC no need to move the file at all! You'd just use a Communication Handle to open the file, then start parsing...

    Here’s an example that parses a different kind of file, but it’ll give you an idea of what it’s like to open/read from a file:

Do any of those methods sound like something that could work for your situation?


That’s awesome. Thanks optomary!