automatically get information and input excel or numbers

Discussion in 'Mac Programming' started by kermgg, Apr 16, 2010.

  1. kermgg macrumors newbie

    Apr 15, 2010
    is there a way to write a program that will automatically get information like yahoo stock quotes and input data into excel or numbers. i also like to be able get data at defiant times of the day. if i can only get the data into excel or number without cutting and pasting that will be a lot easier :)
  2. Mernak macrumors 6502

    Apr 9, 2006
    Kirkland, WA
    Not sure exactly how to input stuff into Numbers/Excel, but a simple way of getting the data you want is using with some extra options at the end. Eg., would give something like the string "130.75,125.20,"-3.55%” (startPrice, currentPrice, percentageChange). The stuff after the ? is a cgi script (that returns the info in CSV, comma separated values, with arguments, s=theTickerSymbol and f=oap2 does something I think making it the format that is returned, but you will probably have to Google details if you want something else.
  3. lee1210 macrumors 68040


    Jan 10, 2005
    Dallas, TX
  4. kermgg thread starter macrumors newbie

    Apr 15, 2010
    need to find the right automator for excel

    after looking into what i have and what need for excel. i found that it would be helpful if i had excel business mac 2008. i have the home and student version of excel. in the business version you get automator workflows that automat task. now i need to learn applescript/programing to write my own automator for excel.

Share This Page