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:
- 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:
- Are you using PAC Display, and have you considered using recipes? Here's a webinar that shows how/when to use those:
- 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?