Join useThinkScript to post your question to a community of 21,000+ developers and traders.
Mashume - Thank you for your quick response and suggested approaches. I would like to obtain the dynamic OHLC candle data in real time during the trading day. The Market Watch screen would be the logical place to insert that data since the table is updating in real time and the columns for O, H andL already exist. The issue I believe is that TDA does not wish to provide the data for what ever reason unknown to me. I like the TDA venue and is very helpful for simple trades and analysis. Trading options is another story requiring as much data as possible to make useful analysis of positions and to determine entry and exit points. I understand that candles also provide a good sense of market psychology and would be a valuable asset to have that data exported to Excel in real time as is all of the other data as well. Seems to me that adding the OHLC data would involve a simple coding modification since the data is available as expressed in a candle chart. I may need to find another platform to realize my goal. Thanks again.
' vba code
' module1
Sub timer()
' run a macro every sec
Application.OnTime Now() + TimeValue("00:00:01"), "main"
End Sub
Sub main()
' row counter
m = m + 1
' put time in row m at column 1
Cells(m, 1) = Now
' pull stock data value from D1, put in row m at column 2
Cells(m, 2) = Cells(1, 4)
' call other macro
timer
End Sub
| Company Name/Ticker | Period | Cost Price $ | Current $ | Shares ($1000) | % Inc/Dec | Profit/Loss $ |
| AXOGEN, INC. (XNAS:AXGN) | Nov. 1, 2021 - Nov 30, 2021 | $ 15.19 | $ 15.87 | 66 | 4.48% | $ 44.77 |
| CAPITAL SENIOR LIVING CORPORATION (XNYS:CSU) | Nov. 1, 2021 - Nov 30, 2021 | $ 27.58 | $ 29.21 | 36 | 5.91% | $ 59.10 |
| CARDIFF ONCOLOGY, INC. (XNAS:CRDF) | Nov. 1, 2021 - Nov 30, 2021 | $ 5.87 | $ 6.11 | 170 | 4.09% | $ 40.89 |
| Customers Bancorp, Inc. (XNYS:CUBI) | Nov. 1, 2021 - Nov 30, 2021 | $ 53.29 | $ 59.19 | 19 | 11.07% | $ 110.71 |
| EVANS BANCORP, INC. (XNYS:EVBN) | Nov. 1, 2021 - Nov 30, 2021 | $ 39.95 | $ 39.85 | 25 | -0.26% | $ (2.63) |
| LENDINGCLUB CORPORATION (XNYS:LC) | Nov. 1, 2021 - Nov 30, 2021 | $ 45.96 | $ 47.02 | 22 | 2.31% | $ 23.07 |
| LEVEL ONE BANCORP, INC. (XNAS:LEVL) | Nov. 1, 2021 - Nov 30, 2021 | $ 31.41 | $ 35.83 | 32 | 14.07% | $ 140.70 |
| MVB FINANCIAL CORP. (XNAS:MVBF) | Nov. 1, 2021 - Nov 30, 2021 | $ 42.69 | $ 43.83 | 23 | 2.67% | $ 26.70 |
| Olin Corporation (XNYS:OLN) | Nov. 1, 2021 - Nov 30, 2021 | $ 56.98 | $ 61.03 | 18 | 7.11% | $ 71.08 |
PATRIOT TRANSPORTATION HOLDING, INC. (XNAS ATI) | Nov. 1, 2021 - Nov 30, 2021 | $ 15.33 | $ 15.99 | 65 | 4.30% | $ 42.99 |
| Totals | 5.57% | $ 557.38 | ||||
| S&P 500 INDEX | $ 4,605.38 | $ 4,654.23 | 1.06% |
yes, @bobmarley solution only works in Excel, completely separate from TOS
you say the prices auto update. i think #4 poster was thinking you could add a column in tos that calculates the ema. then export it to excel, then copy that formula to your sheet, so it would pull in the desired ema.
this post has a link, to a site that describes the formulas for calculating the ema. it has a excel file you can download.
=RTD("tos.rtd",,"LAST", "/ZN:XCBT")
=RTD("tos.rtd",,"LAST", "/ZN:XCBT") price as text, RTD( )
=LEN(A2) length data text
=SEARCH("'",A2,1) decimal location
=A3-A4 right char len
=LEFT(A2,A4-1) left digits
=MID(A2,A4+1,A5) right digits
. decimal point
=VALUE(A7&A9&A8) price converted to number
1 some number
=A11*A12 number x price| Thread starter | Similar threads | Forum | Replies | Date |
|---|---|---|---|---|
| V | Exporting | Questions | 1 | |
| W | Exporting Multiple Watchlists to Google Sheets | Questions | 1 | |
| M | Exporting RTD option Greeks to Excel | Questions | 1 | |
| C | Exporting Option Chain Open Interest? | Questions | 3 | |
|
Exporting Scan Settings | Questions | 1 |
useThinkScript is the #1 community of stock market investors using indicators and other tools to power their trading strategies. Traders of all skill levels use our forums to learn about scripting and indicators, help each other, and discover new ways to gain an edge in the markets.
We get it. Our forum can be intimidating, if not overwhelming. With thousands of topics, tens of thousands of posts, our community has created an incredibly deep knowledge base for stock traders. No one can ever exhaust every resource provided on our site.
If you are new, or just looking for guidance, here are some helpful links to get you started.