Utilities
WinPicks Reference Manual Section 10. Utilities
This section discusses some features that were included to make WinPicks as versatile as possible. These features cover the Data Sources window, getting help, and exporting the WinPicks database so it can be used by other applications. To copy any report to the clipboard, choose Edit > Copy to Clipboard; for large amounts of data, use the Export features below.
This section covers the following topics:
- 10.2 - Changing the Data Directory
- 10.4 - Getting Help
- 10.5 - Exporting Data to Microsoft Excel
Changing the Data Directory
The original program stored its database in a folder on your computer and let you point it somewhere else - a second drive, or a shared folder on a network. WinPicks 2.0 keeps the database on the server. Your formulas, your saved trends, your tuner settings and your price basis are stored with your account, and reach you on any machine you sign in from. There is no folder to choose and nothing to back up.
The menu item remains, and now opens a small window called Data Sources. It reports where the server keeps each sport's formulas, how many are stored, and whether every screen is reading the same copies - and if two copies of a formula ever disagree, it says so and offers the repair. Most customers will never need it; it exists so that the answer to "where is my work, exactly?" is a screen rather than a support question.
Getting Help
WinPicks Reference Manual Section 10.4. Getting Help
WinPicks has an extensive help section that includes all the text from this reference manual. To use it, select CONTENTS from the HELP menu, or press F1.
The HELP menu also includes a TREND COMMAND REFERENCE, which documents the command grammar the Trend Finder accepts (see section 9), and SHOW ALL MESSAGES AGAIN, which brings back any explanatory messages you have dismissed with "don't show this again".
There is no CHECK FOR SOFTWARE UPDATES item any more, and nothing to check: WinPicks 2.0 is maintained on the server, so a fix or a new feature is simply there the next time you sign in.
If you have a question this manual does not answer, or you find a mistake in the program or in the data, choose MY ACCOUNT from the HELP menu and follow the Contact link on your account page. We respond to most questions within 24 hours.
Exporting Data to Microsoft Excel
WinPicks Reference Manual Section 10.5. Exporting Data to Microsoft Excel
Nearly all of the data in the WinPicks database can be exported. WinPicks generates comma-separated value (.csv) files, which Microsoft Excel opens directly - as does any other spreadsheet, database, or programming language.
The original program could also start Excel itself and fill in a worksheet. A browser cannot start programs on your machine, so that option is shown in the export window but disabled; choosing .csv gives you exactly the same data. The exported file arrives through your browser's normal download.
There are three different export features in WinPicks, and each is described below.
Export Current Report. Display any report on the screen, then select EXPORT CURRENT REPORT from the FILE menu. Whatever report is on screen is saved as a .csv file.
Export Games (Scores, Lines, Stats by Date). Select EXPORT GAMES from the FILE menu. The window shown in Figure 10.51 will appear, and you can export the entire database or a range of dates.
Figure 10.51 - The Export Data Window
When this option is used with Pro Football Analyst (PFA), it exports the date, Nevada rotation number, score, pointspread, and totals (over/under) information, as well as all of the game statistics found in the boxscore. The other four packages export the date, rotation number, score, pointspread, and totals information. Rotation numbers are only included for games with odds, odds (particularly totals) are not included for some games, and rotation numbers are missing for CFA, PFA, and PBA games prior to 1997.
All packages contain all regular season and postseason games in their database, dating back to 1985 for the football versions, to 1990 for PBA, and to 2000 for CBA. Many thousands of games are exported if you select all games with this feature.
Export Team Database (totals). Select EXPORT TEAM DATABASE from the FILE menu to export the information found in the database about each team, including won/loss records, against the spread (ATS) and totals records, and average margin of victory (AMOV) at home and on the road - plus, in Pro Football Analyst, the game statistics found in the boxscore. The amount of information exported depends upon the database method that is currently in use.