Difference between revisions of "SDC Platinum (Wiki)"
| (9 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | {{ | + | {{Project |
| + | |Has project output=Tool,How-to | ||
|Has image= | |Has image= | ||
|Has title=SDC Platinum (Wiki) | |Has title=SDC Platinum (Wiki) | ||
| Line 6: | Line 7: | ||
|Has deadline= | |Has deadline= | ||
|Has keywords=Tool | |Has keywords=Tool | ||
| − | | | + | |Has sponsor=McNair Center |
|Has notes= | |Has notes= | ||
|Has project status=Complete | |Has project status=Complete | ||
| Line 12: | Line 13: | ||
|Does subsume= | |Does subsume= | ||
}} | }} | ||
| − | + | ==Using SDC Platinum== | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
'''Login Information''' | '''Login Information''' | ||
| − | *User Initials: | + | *User Initials: EE |
| − | *Enter project description | + | *Enter project description, e.g. 1 |
'''Create a New Project''' | '''Create a New Project''' | ||
| Line 52: | Line 47: | ||
*Select USR | *Select USR | ||
*left click on your text file, select open with TextPad | *left click on your text file, select open with TextPad | ||
| + | |||
| + | ==Example Session== | ||
| + | |||
| + | For example we might want to obtain information about executives of portfolio companies which received in British Columbia. | ||
| + | |||
| + | Run SDC Platinum, and login in with User Initials "'''EE'''" (without quotes). Fill in project description (type anything - just the number 1 is fine). Select '''VentureXpert''' and select '''Portfolio Companies''' under '''Industry Resources'''. Select '''Search Menu''' in Navigation Method (never select Express Reports). Double click '''Company Area Cd''' under '''Portfolio Company'''. Double click '''All Canada''' and select all '''British Columbia''' rows by double clicking. Open '''Venture Related Deals''' under Investment Type and then select '''All Venture Related Deals'''. Under '''Investment Summary''', open '''Date Company Rcvd its First Investment''' and set the dates. Exit search window and click on the '''Report''' button on the tool bar. Select '''Custom''' and find whatever information you want to display in the report, such as Company Name and Address, add them by double clicking. Click '''OK''' and click '''OK''' again on the right hand side of the window. Select '''No''' when asked to return to design mode. Input name for custom report and save. Choose '''Column Grid format''' and save as txt file. Click '''Execute''' on the top to generate the report. | ||
| + | |||
| + | ==Potential Errors== | ||
| + | |||
| + | If you are opening a custom report and the rpt file you are looking to use to extract doesn't appear, there was a mistake in your choice of database. For example, when attempting to pull data relating to funds or rounds you sometimes have to chose Portfolio Companies in the VentureXpert database. Play around with choosing different filters within the database. Choice of which database to pull each type of data from can be found on the [[VentureXpert Data]] page. | ||
| + | |||
| + | Occasionally an error will appear at the end of extraction which reads Out of Memory. This error does not occur because we do not have enough memory so do not delete anything. Rather, it occurs because of defective memory processing in the program itself especially when running a custom script. To fix this problem either completely restart SDC (maybe even log out of the RDP) and rerun the program. If this doesn't work, go into the rpt file that you are running and slightly change something. For example, change 6/17/2018 to 06/17/2018. This worked for me and my data was successfully extracted. | ||
| + | |||
| + | If SDC won't shut down or reopens immediately if you restart RDP, go to Task Manager and force quit it. If this still does not work, you will need administration privileges to shut down SDC. Ask someone with this power, and your problem should be fixed. | ||
| + | |||
| + | On my last big usage, SDC reported an access violation at the end of pretty much every pull. This doesn't affect the output. Just say ok. It doesn't seem to affect the next run. | ||
Latest revision as of 12:48, 21 September 2020
| SDC Platinum (Wiki) | |
|---|---|
| Project Information | |
| Has title | SDC Platinum (Wiki) |
| Has owner | Ben Baldazo |
| Has start date | |
| Has deadline date | |
| Has keywords | Tool |
| Has project status | Complete |
| Has sponsor | McNair Center |
| Has project output | Tool, How-to |
| Copyright © 2019 edegan.com. All Rights Reserved. | |
Using SDC Platinum
Login Information
- User Initials: EE
- Enter project description, e.g. 1
Create a New Project
- Enter Project Description
- Select a Database
- VentureXpert
- Choose Industry Resource
- Global New Issues Databases
- Mergers & Acquisitions
- VentureXpert
- Select Search Menu
- In Search Items:
- Select Moneytree Deals or Venture Related Deals
- Select all other filters needed for the analysis (i.e. dates or state)
- Fill out custom time frame for filters requiring dates
- In Express Report Items (Under report in top bar, create custom report):
- Select all variables for analysis (double click)
- Select OK on far right column
- Save custom report
- In report options: select 'Save As' from the row of tabs at the top
- Enter file name and save the report to a text file (.txt)
- Select Execute to generate a report
To Open the Report in TextPad
- Open Documents from Windows Menu
- Select Local Disk (C:)
- Select SDC
- Select 4.0.3.1
- Select Platinum
- Select USR
- left click on your text file, select open with TextPad
Example Session
For example we might want to obtain information about executives of portfolio companies which received in British Columbia.
Run SDC Platinum, and login in with User Initials "EE" (without quotes). Fill in project description (type anything - just the number 1 is fine). Select VentureXpert and select Portfolio Companies under Industry Resources. Select Search Menu in Navigation Method (never select Express Reports). Double click Company Area Cd under Portfolio Company. Double click All Canada and select all British Columbia rows by double clicking. Open Venture Related Deals under Investment Type and then select All Venture Related Deals. Under Investment Summary, open Date Company Rcvd its First Investment and set the dates. Exit search window and click on the Report button on the tool bar. Select Custom and find whatever information you want to display in the report, such as Company Name and Address, add them by double clicking. Click OK and click OK again on the right hand side of the window. Select No when asked to return to design mode. Input name for custom report and save. Choose Column Grid format and save as txt file. Click Execute on the top to generate the report.
Potential Errors
If you are opening a custom report and the rpt file you are looking to use to extract doesn't appear, there was a mistake in your choice of database. For example, when attempting to pull data relating to funds or rounds you sometimes have to chose Portfolio Companies in the VentureXpert database. Play around with choosing different filters within the database. Choice of which database to pull each type of data from can be found on the VentureXpert Data page.
Occasionally an error will appear at the end of extraction which reads Out of Memory. This error does not occur because we do not have enough memory so do not delete anything. Rather, it occurs because of defective memory processing in the program itself especially when running a custom script. To fix this problem either completely restart SDC (maybe even log out of the RDP) and rerun the program. If this doesn't work, go into the rpt file that you are running and slightly change something. For example, change 6/17/2018 to 06/17/2018. This worked for me and my data was successfully extracted.
If SDC won't shut down or reopens immediately if you restart RDP, go to Task Manager and force quit it. If this still does not work, you will need administration privileges to shut down SDC. Ask someone with this power, and your problem should be fixed.
On my last big usage, SDC reported an access violation at the end of pretty much every pull. This doesn't affect the output. Just say ok. It doesn't seem to affect the next run.
