| ♥ 0 |
I was able to export real time quotes to excel without problems, it worked very well So I was wondering if it’s possible to Export real-time custom alerts to excel Whenever a certain condition is respected
Marked as spam
|
Posted by |
Private answer
No, not in real time. You can export the contents of the message center to a .csv file. That would give you a list of all the notifications that have occurred. But reading real time alerts from an Excel spreadsheet does not appear to be possible. Best you can do is create a custom column in a watchlist. The code in the custom column would mirror you alert code. You would then use the very same method of exporting real time quotes. The custom column would be included in that export and display values relative to the conditions specified. Marked as spam
 Posted by Pete Hahn (Questions: 37, Answers: 4087) Answered on May 16, 2017 10:17 am
|
This would be a clever approach for sure
I tried doing this here.
so I clicked on ”MarketWatch”
then I clicked on ”Quotes”
But I could not add a custom column
What would be the way to do that?
The method to add a custom column in the MarketWatch tab is identical to adding one to any ordinary watchlist. If you are not sure how to add a custom column to a watchlist I encourage you to view any of our videos on the topic.