MarketXLS requires some details from Twitter and Stocktwits for Social Integration:
To get Twitter information you need to go to https://dev.twitter.com
- Click on My Apps
- Click on Create New App
- Fill in the details as requested in the form
- Please note that Website and Call back URLs should start with https://
- Click on the checkbox to agree with the Twitter agreement
- Click on Create Your Twitter Application
- On the new page, click on Keys and Access Tokens
- The Consumer Key (API Key) and Consumer Secret (API Secret) will give you input for first two values needed.
- For Access Token and Secret, scroll down and click on Create my access token and it will give you the values for the other two.
Adding Details in MarketXLS for Social Integration
Under MarketXLS tab in you Excel, Click on Settings under Help and Settings.
To connect with Twitter
Share the below mentioned details in the pop-up box and click on Save Twitter Credentials
- Consumer Key
- Consumer Secret
- Access Token
- Access Token Secret
To connect to Stocktwits
- Click on Step 1) Click Here to Connect to Stocktwits
- After login, your code will appear in the pop-up box. Copy-paste the code here.
- Click on Step 2) Save Stocktwits Credentials
The first button – Save Settings – has the default feature of sending your tweet as Media. You can un-check this option and add any separator in the text box next to it.