Stock Bot Commands & Advanced Aliases
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
 
A
1
Important Usage Info
2
3
In order to use this spreadsheet, you must first copy it to your Google account. To do so, click here or go to the File > Make a copy pull down menu above. Once copied, continue below to learn how to use.
4
5
Overview
6
This sheet is made available to those that would like to view the list of Stock Bot commands and advanced aliases in a spreadsheet. This sheet contains a sheet tab named Commands for commands and simple aliases and a sheet tab named Advanced Aliases for default, server and user advanced aliases. See terminology section below for explanation of terms.

If you operate your own Discord, check the Discord Servers section below to learn how to make a customized copy for your Discord that you can share with your members.

If you are a Discord member, check the Discord Members section below for how to customize and use.

For those wishing to create their own sheet using real time comma serparated values (CSV) files that generate this sheet, check the Advanced Users section below.

For those looking for a simple list of commands and descriptions, click here.
7
8
Discord Servers
9
10
You can make a custom copy of this sheet available to members of your Discord. The custom copy will include any customizations made to the bot settings in the administrative interface such as changes to the command prefix, aliases and advanced aliases. To setup, do the following.
11
12
1) If you have not already, save a copy of this sheet to your Google account by clicking here or going to File > Make a copy pull down menu above.
13
14
2) Type server command in your server to get your server ID and enter it into cell B3 on the Settings sheet tab.
15
16
3) Click the Share button in upper right and select "Anyone with link" and "Viewer" as the share type and copy URL to share with your members. The reason to select "Viewer" is to protect your copy of the sheet from being edited. Once members copy it to their own account as instucted below, they will be able to use and edit it.
17
18
Discord Members
19
20
Members, follow the steps below to use sheet.
21
22
1) If you have not already, save a copy of this sheet to your Google account by clicking here or going to File > Make a copy pull down menu above.
23
24
2) After saving to your account, use the Commands and Advanced Aliases sheet tabs to view and filter the data.
25
26
3) If you wish to customize the output to include any favorite commands you may have saved on the commands page or user advanced aliases you may have created, type the user command and go to the Commands > Favorites menu section for your API Key and setup instructions.
27
28
Advanced Users
29
30
Google Sheet Users
31
32
If you want to create your own sheet instead of using this one, you can use the following formula to import the CSV files containing the raw data into any Google sheet which you can then filter to show just the data you want using formulas similar to the ones used in this sheet.
33
34
=IMPORTDATA("https://stockbot.us/api/v1/commands/?serverId=&apiKey=")
35
=IMPORTDATA("https://stockbot.us/api/v1/advancedAliases/?serverId=&apiKey=")
36
37
Other Spreadsheet Users
38
39
For Excel or other spreadsheets that support import of CSV files, the file locations to use in your formula to import the raw data are below.
40
41
42
For Commands
43
https://stockbot.us/api/v1/commands/?serverId=&apiKey=
44
45
For Advanced Aliases
46
https://stockbot.us/api/v1/advancedAliases/?serverId=&apiKey=
47
48
Optional Query Strings
49
50
You can add the following query strings to the URLs to modify the output of the data. In below examples, the commands API endpoint is used but you could also use the advancedAliases API endpoint.
51
52
Name: serverId
53
Description: Adds support to return server specific info. Things that may change include command prefix, simple aliases and server advanced aliases. If you don't specify any, the default values for each that come with all servers are returned.
54
Example:
55
https://stockbot.us/api/v1/commands/?serverId=someServerId
56
57
Name: apiKey
58
Description: Adds support to return member specific info. Things that change include user advanced aliases and favorites. If you don't specify any, the default values for each that are available to all users are returned. Your API key can be retrieved by typing the user command to visit the bot's user interface and going to the Commands > Favorites menu section.
59
Example:
60
https://stockbot.us/api/v1/advancedAliases/?apiKey=yourApiKey
61
62
Example of both optional query strings together:
63
64
https://stockbot.us/api/v1/commands/?serverId=someServerId&apiKey=yourApiKey
65
66
Tabs Of This Sheet
67
68
This example sheet is made up of 7 sheet tabs (3 are hidden) as explained below.
69
70
Sheet Tab Name: Info
71
Description: This sheet tab containing information on using this sheet and the CSV file locations.
72
73
Sheet Tab Name: Settings
74
Description: Contains beige colored cells at top to add an optional server id, API Key and force the sheet to refresh.
75
76
Sheet Tab Name: Commands
77
Description: Contains beige colored cells at top to filter the raw data by command category, command name, alias name and favorites (if API Key provided). Use this sheet tab to find command names and their simple aliases.
78
79
Sheet Tab Name: Advanced Aliases
80
Description: Contains beige colored cells at top to filter the raw data by command category, command name, advanced alias name and favorites (if API Key provided). Use this sheet tab to find default, server and user advanced aliases.
81
82
Sheet Tab Name: Commands CSV
83
Description: Hidden, imports the raw command data from the Stock Bot CSV file.
84
85
Sheet Tab Name: Advaned Aliases CSV
86
Description: Hidden, imports the raw advanced aliases data from the Stock Bot CSV file.
87
88
Sheet Tab Name: Lists
89
Description: Hidden, creates a lists of items for use in the Commands & Advanced Aliases sheet tabs.
90
91
Terminology
92
93
Commands & Aliases
94
95
Commands can have aliases which are just an alternative way to run the command. The commands and their aliases, if any, can be viewed on the Commands sheet tab.
96
97
Advanced Aliases
98
99
Advanced aliases are ways to instruct the bot to return custom data. They can return different types of data including the following.
100