Re: Streaming Real-Time Stock Quotes in Mathematica
- To: mathgroup at smc.vnet.net
- Subject: [mg104020] Re: Streaming Real-Time Stock Quotes in Mathematica
- From: Ariel Sepúlveda <ariel.sepulveda at prontoanalytics.com>
- Date: Fri, 16 Oct 2009 07:17:31 -0400 (EDT)
I use BEST Schedules (http://www.prontoanalytics.com/products/schedules.htm) to schedule Mathematica tasks from real-time to weekly or monthly reports. With this tool you can set exact execution time spans, define job priorities in case two jobs are scheduled to run at the same time, and also block execution for any non-interesting conditions (e.g. weekends or night-time). This scheduler runs 7-24, thus it will use one of the two Mathematica processes usually available in default configurations. Jobs scheduled can be any Mathematica script. These scripts usually don't generate output cells but create output is data (csv, xls, etc.) or graphical (gif, png, etc.) files. This is a tool that I usually combine with data manipulation and analysis functions in MXLPlus or BEST Viewpoints. Although I frequently need to combine Mathematica with spreadsheets to meet my client needs, I usually find a way around them when generating Mathematica solutions. My contact info is in Contact Us in my web site http://www.prontoanalytics.com/index.htm. -----Original Message----- From: Stewart Bodzin [mailto:Stewart.Bodzin at usa.net] Sent: Thursday, October 15, 2009 7:16 AM To: mathgroup at smc.vnet.net Subject: [mg104020] [mg104000] Streaming Real-Time Stock Quotes in Mathematica Has anyone successfully used YaHoo real-time streaming quotes (a premium subscriber service) within a Mathematica model? I have built some financial models that use quote data from excel spreadsheets, but would like to access streaming quotes. One idea is to access an excel spreadsheet that already receives streaming updates but I don't know how to link Mathematica to an open and running spreadsheet instead of the static spreadsheet file. If anyone has experience in this area, some help would be immensely appreciated. Thanks, Stewart G. Bodzin Pleasant Hill, California eMail: <mailto:stewart.bodzin at usa.net> stewart.bodzin at usa.net