The other mode is called 1904 Date System and is used for compatibility with Excel 2008 for Mac and earlier Mac versions. You can change the date system in the Advanced Options. In the 1904 date system dates are calculated using 1st January 1904 as the starting point. How to Install Custom Quote Columns in ThinkOrSwim This video shows how to install custom quote columns from ThinkScript code for use in sidebar watchlists, in MarketWatch Quotes screens, and StockHacker scanner results lists on the ThinkOrSwim platform. This is my Think-Or-Swim download page featuring all the ThinkScripts I’ve written for the Thinkorswim platform from TD Ameritrade. My goal with this site is to have fun programming and to provide some useful tools for my fellow TOS traders in the meantime. Example Excel File. After you've downloaded and installed the Add-In, please see my sample Excel file to see how this works! The Excel Quote Add-In works by providing a new Excel function (aka formula) called =QUOTE. It can be used to retrieve quote data like last, open, day high/low, year high/low, etc. 64-bit Emulator Mac Excel For Mac Rtd Functions Think Or Swim Best Gmail Chat For Mac How To Count How Many Cells Are Selected In Excel For Mac Install Font For Photoshop Mac Is There Free Mac Software Or App For Securing Data On The Internet Microsoft Paint App For Mac View Page Source Google Chrome For Mac.
How great would it be if you could go back in time and learn from your past mistakes? Maybe you would have taken that job offer, married your high school sweetheart, or passed on drinking that expired milk?
Of course, reliving the past is just a fantasy, right? Well, not with thinkorswim OnDemand, a powerful stock backtesting tool available on the TD Ameritrade thinkorswim trading platform. It lets you replay past trading days to evaluate your trading skill with historical data.
That’s right. The tool has recorded virtually each market tick, so you can backtest stock, forex, futures—you can even backtest options trading strategies—all the way back to December 2009. You can even see Level II quotes (essentially the NASDAQ order book). It’s all waiting for you in OnDemand.
What Can You Do with OnDemand?
- Run the backtesting software platform 24/7, including nights and weekends
- Watch tick-by-tick price changes for stocks, futures, forex, and options
- Simulate trading just as you would in a live trading account, except with historical rather than real-time data
- Watch the profit or loss of simulated positions as the “trading day” proceeds, or as you fast-forward to another date
- Find historical data as far back as December 6, 2009
In short, the OnDemand platform is a tool for backtesting trading strategies, that both short-term and long-term investors can use to evaluate their skills.
For example, if you are a day trader, you can see how your strategies would have held up during market-moving events like Fed announcements, earnings reports, or even the “Flash Crash”—which occurred intraday.
For those with a longer-term investment approach, you can see how a simulated portfolio would have performed when the overall market was bullish, bearish, or neutral, as well as how world events and macroeconomic news would have affected your profit and loss.
Just keep in mind that results are hypothetical, and there is no guarantee the same strategy implemented today would yield the same results.
How to Use OnDemand
The OnDemand platform is accessed from your live trading screen, not paperMoney. So, log on to thinkorswim as you normally would. When you are ready to start OnDemand, click the button in the upper right-hand corner of your platform (figure 1).
FIGURE 1: INITIALIZING THINKONDEMAND.
First, click the “OnDemand” icon, found in the upper right-hand corner. Image source: Thethinkorswim® platform from TD Ameritrade. For illustrative purposes only. Past performance does not guarantee future results.
You’ll notice a few changes that indicate you are not trading live money (figure 2).
- A pop-up window gives an overview of OnDemand’s capabilities
- The “OnDemand” button will be shaded orange and a calendar will appear next to it
- The entire platform will have an orange border around it
Your “Account Info” section in the upper left-hand corner will be set to $100,000, with a note below it indicating “These are simulated values.” Now you can click the calendar and set the date and time to any point from December 2009 forward. Once you’ve done that, you can place trades as you normally would; your order confirmation window will indicate that each is an “OnDemand Virtual Order.” You can let the tick data run and pause it whenever you want, or fast-forward to another date/time to see how your profit and loss is affected.
Rtd In Excel
FIGURE 2: THINKORSWIM ONDEMAND VIRTUAL MODE.
Once your account moves into backtesting mode, you can select the date and time and trade a simulated $100,000 account. Image source: Thethinkorswim® platform from TD Ameritrade. For illustrative purposes only. Past performance does not guarantee future results.
![Rtd Rtd](/uploads/1/1/4/2/114236707/841089997.jpg)
Let’s say you’ve placed a number of trades and tried out some backtesting strategies, but want to tweak them to see if they could have performed better. Simply click the “reset” icon—the circular arrow next to “Account Info”—to erase all your virtual trades and reset your account value back to $100,000.
When you have finished backtesting and are ready to resume live trading, simply click the orange “OnDemand” button again and your platform will take you back to the present.
Excel Quotes Add-In
Excel Quotes Add-In has been broken recently due to changes in Microsoft's Quote Web Services. Please see this post for more information.
On 6/30/2019, I have revere-engineered the new Quote Web Services and updated my Excel Quotes Add-In with the changes. Please download the most recent version and copy over the previously saved QuotesAddIn.xll file on your computer.
On 6/30/2019, I have revere-engineered the new Quote Web Services and updated my Excel Quotes Add-In with the changes. Please download the most recent version and copy over the previously saved QuotesAddIn.xll file on your computer.
A long time ago, my team at Microsoft built an Excel plug-in to get stock quotes from MSN Money. It looked something like this: MSNStockQuote('MSFT','Last').
Unfortunately Microsoft hasn't supported this plug-in for years :(
While building MSMoneyQuotes, I reconginzed Excel was still lacking a decent Add-In to get quotes. So I built one!
The Excel Add-In I developed uses Microsoft's own quote web services to retrieve quotes. Therefore it supports getting quotes for any securities that work on the MSN Money website and/or the Windows 10 Money app. I also added the ability to get cryptocurrency quotes using the CryptoCompare API.
I have made it freely available from my website. However, I do accept donations which help offset the many hours put towards building, improving and supporting this software.
Unfortunately Microsoft hasn't supported this plug-in for years :(
While building MSMoneyQuotes, I reconginzed Excel was still lacking a decent Add-In to get quotes. So I built one!
The Excel Add-In I developed uses Microsoft's own quote web services to retrieve quotes. Therefore it supports getting quotes for any securities that work on the MSN Money website and/or the Windows 10 Money app. I also added the ability to get cryptocurrency quotes using the CryptoCompare API.
I have made it freely available from my website. However, I do accept donations which help offset the many hours put towards building, improving and supporting this software.
Prerequisites
- Works with Desktop Excel 2010, 2013, 2016
- Supports 32 bit and 64 bit versions of Excel
- Built as an 'Excel Add-In', which is a special DLL with an XLL file extension
- Adds a new '=QUOTE()' function to make getting quotes easy
- Adds a new 'Quotes' tab to make finding and updating quotes easy
- Supports updating quotes for all securities supported by the MSN Money website
- Supports updating cryptocurrency quotes supported by the CryptoCompare API
Download and Install
- First determine which bit version of Excel you have installed using What version of Office am I using?
- Download the appropriate 32-bit version or 64-bit version of QuotesAddIn.xll and save on your computer (e.g. C:GaierSoftwareQuotesAddIn.xll)
- Add/Enable the Add-In in Excel using the 'Browse' option. Add or remove add-ins in Excel
- Click File/Options then click 'Go' next to Manage Excel Add-ins
- Click 'Browse...', navigate to the folder where you saved the QuotesAddIn.xll and select it
Dowload the 32 bit version - QuotesAddIn.xll
Dowload the 64 bit version - QuotesAddIn64.xll
Example Excel File
After you've downloaded and installed the Add-In, please see my sample Excel file to see how this works!
QuotesAddInExample.xlsx
QuotesAddInExample.xlsx
Basic Usage
The Excel Quote Add-In works by providing a new Excel function (aka formula) called =QUOTE(). It can be used to retrieve quote data like last, open, day high/low, year high/low, etc.
The function accepts two parameters:
The function accepts two parameters:
- Financial Instrument: This the special symbol MSN Money (and Morningstar) assigns to the security to uniquely identify it. Because MSN Money supports many international markets the symbol 'GOOG', for example, is not enough to uniquly identify Google. Instead, MSN Money uses the following Finanical Instrument to indentify Google: '126.1.GOOG.NAS'. Financial Instrument Search Page
- Quote Field: This indicates which quote field you'd like to retreive. See the 'Supported Quote Fields' for the complete list.
Example Usage:
How to determine the appropriate 'Financial Instrument' symbol
I've build it a basic search pane that makes finding a MSN Money supported financial instrument easy. Go to the custom 'Quotes' tab and click the 'Search' button.
The 'Quotes' tab has a 'Search', 'Update Now' and 'Start Auto Update' buttons:
In the search pane, you can search by symbol or company name and hopefully find what you're looking for. Just start typing in the search field and the listbox will automatically load relevant results. This uses the same search service used by the MSN Money website, so I can't control the search behavior and/or results.
Once you find what you're looking for, you have the option to:
The 'Quotes' tab has a 'Search', 'Update Now' and 'Start Auto Update' buttons:
In the search pane, you can search by symbol or company name and hopefully find what you're looking for. Just start typing in the search field and the listbox will automatically load relevant results. This uses the same search service used by the MSN Money website, so I can't control the search behavior and/or results.
Once you find what you're looking for, you have the option to:
- Select the Quote Field you'd like to get a value for and click 'Insert Forumla' to insert the applicable =QUOTE() forumla
- Select 'Financial Instrument' to insert the raw financial instrument into the currently active call. This does not insert a formula. This may be useful if you're using the second approach [e.g. =QUOTE(A1, 'Last')] where you're referencing another cell to get the financial instrument.
Cryptocurrency Support
Cryptocurrencies are a hot topic recently, so I also added support for those. I leverage the CryptoCompare API to get quotes.
If you know the cryptocurrnecy pair, you can simply type the formula directly into the cell. For example: Or you can use the 'Cryptocurrency' tab in the search pane. Same as the other tab, start typing in the search field and relevant results will show up.
If you know the cryptocurrnecy pair, you can simply type the formula directly into the cell. For example: Or you can use the 'Cryptocurrency' tab in the search pane. Same as the other tab, start typing in the search field and relevant results will show up.
Supported Quote Fields
Here's a list of Quote Fields and which security types they're generally applicable to. Not all fields work for every security.Excel For Mac Rtd Functions Think Or Swim Suit
Quote Field | Indexes | Stocks | ETFs | Funds | Currency Rates | Cryptocurrencies |
---|---|---|---|---|---|---|
Symbol | X | X | X | X | X | X |
Name | X | X | X | X | ||
Currency | X | X | X | X | ||
Last | X | X | X | X | X | X |
Change | X | X | X | X | X | X |
Date | X | X | X | X | X | |
Type | X | X | ||||
Exchange | X | X | X | |||
Previous Close | X | X | X | |||
Day High | X | X | X | X | ||
Day Low | X | X | X | X | ||
Open | X | X | X | X | ||
PE | X | |||||
EPS | X | |||||
Volume | X | X | X | X | ||
Avg Volume | X | X | X | |||
Year High | X | X | X | X | ||
Year High | X | X | X | X | ||
Market Cap | X | X | ||||
Ask | X | X | X | |||
Beta | X | |||||
Bid | X | X | X | |||
Dividend Yield | X | X | ||||
Industry | X |
How to update quotes
Once the cell(s) are setup with the proper =QUOTE() forumla, you can go to the custom 'Quotes' tab and click the 'Update Now' button. This button forces a 're-calculation' of all =QUOTE() forumulas, which invokes my add-in to retrieve quotes from the relevant web service APIs.
To automatically update quotes every 1 minute, click the 'Start Auto Update' button. Essentially this starts a timer to automatically run the 'Update Now' logic every minute.
Click 'Stop Auto Update' to stop the auto update timer.
Note: Quotes are cached for 30 seconds, so the if you try to click the 'Update Now' button more often than that nothing will happen.
To automatically update quotes every 1 minute, click the 'Start Auto Update' button. Essentially this starts a timer to automatically run the 'Update Now' logic every minute.
Click 'Stop Auto Update' to stop the auto update timer.
Note: Quotes are cached for 30 seconds, so the if you try to click the 'Update Now' button more often than that nothing will happen.
Help and Support
I've made this free to avoid creating a sense of obligation that I'll provide support. I don't guarentee it will work in every scenario or that I'll provide support when it doesn't work. With that said, if you do have a problem that you think I can help shoot me an email and I'll reply if I can.
Please recognized I am no longer a Microsoft employee and cannot fix quote issues on MSN Money. Nor can I address outages that the MSN Money quote web service may have. My Excel Quote Add-In is not responsible for the actual quote values returned by MSN Money, so please don't email asking me to fix such issues. Same with the cryptocurrency quotes from the CryptoCompare API.
I can be reached at my support email address: [email protected]
Please recognized I am no longer a Microsoft employee and cannot fix quote issues on MSN Money. Nor can I address outages that the MSN Money quote web service may have. My Excel Quote Add-In is not responsible for the actual quote values returned by MSN Money, so please don't email asking me to fix such issues. Same with the cryptocurrency quotes from the CryptoCompare API.
I can be reached at my support email address: [email protected]
Excel For Mac Rtd Functions Think Or Swim Team
Release History
Excel For Mac Rtd Functions Think Or Swim Trunks
Excel For Mac Rtd Functions Think Or Swim Club
- Version 1.0 - 01/31/2018 - Initial Release
- Version 1.1 - 02/22/2018 - Added Auto Quotes Update
- Version 1.2 - 06/30/2019 - Updated to consume the new Microsoft Quote Services