Google finance intraday live data into Exel sheet

Discussion in 'Intraday' started by murthymsr, Jan 26, 2010.

  1. murthymsr

    murthymsr Well-Known Member

    Joined:
    Sep 25, 2005
    Messages:
    1,113
    Likes Received:
    392
    Trophy Points:
    83
    Location:
    Hyderaabd
    Hi all,

    I want to get intraday live quote data of NSE stocks/Indices into excel sheet from GOOGLE Finance (NOT Yahoo finance). My stock symbols are in one column and I want to get the last traded price & PrevClose or %Change into the next columns.

    Can somebody help me to achieve this with preferably an example?

    Thanks in advance.

    murthymsr
     
    Last edited: Jan 29, 2010
    nac likes this.
  2. rc.trader

    rc.trader New Member

    Joined:
    Jan 24, 2010
    Messages:
    7
    Likes Received:
    5
    Trophy Points:
    3
    HI

    why to get live data in exel form from google or yahoo or esignal or roguters?:annoyed:googel ,yahoo ,esignal ,routes is still secondary data sourse.best take free live excel data from primary data direct NSE software NEAT u can also get many data live in excel like ATR AND opeintestdata. in NEAT..open one trading accout to those broker who gives NEAT trading termianl to all clint.(neat is easily abailbale now ).
    throgugh google u can download last 15 days intrday data..in csv (yahoo gives only only 5 days) but as far as i know google sourse is not live

    now if u want to expert thise live data in ami or ms then solution is also abaliable in market use neatplugin for ami
     
    nac, AMOL007, jagankris and 2 others like this.
  3. NFTRADER

    NFTRADER Member

    Joined:
    Aug 14, 2009
    Messages:
    34
    Likes Received:
    45
    Trophy Points:
    18
    Rc.trader
    can you tell me which brokers are offering neat terminal
    thanx in advance
     
    nac and (deleted member) like this.
  4. jdm

    jdm Well-Known Member

    Joined:
    Jul 7, 2005
    Messages:
    863
    Likes Received:
    477
    Trophy Points:
    63
    murthy,
    you can get the google quotes in google spreadsheet very easily. heres a sample

    http://spreadsheets.google.com/ccc?key=0AobjP3YUJDfWcl9UZUdxNTg4b1hiaGRHRG5PeDAwZ0E&hl=en

    this will get the quotes for google

    last
    =googlefinance("goog","price")

    % change
    =googlefinance("goog","Changepct")

    prev close
    =googlefinance("goog","closeyest")
     
    nac, AMOL007, nifty46 and 5 others like this.
  5. murthymsr

    murthymsr Well-Known Member

    Joined:
    Sep 25, 2005
    Messages:
    1,113
    Likes Received:
    392
    Trophy Points:
    83
    Location:
    Hyderaabd
    Thanks jdm, for your reply, which is very informative and simple.

    I was looking out for a method to get the data into an excel sheet on my hard disk, and NOT the google spread sheet.

    Probably some excel Add-In may be required to achieve this functionality. Something like SMF (StockMarketFunctions) Add-In, which gets a lot of info from very many sources including Google, but not the stock quotes.

    Regards.

    murthymsr
     
    nac and nifty46 like this.
  6. shanki99

    shanki99 Well-Known Member

    Joined:
    Aug 28, 2008
    Messages:
    689
    Likes Received:
    487
    Trophy Points:
    63
    Location:
    Chennai

    jdm

    I use a simple DDE to import RT data from excel to Amibroker. Can the same concept be used to import data from google spreadsheets??
     
    Last edited: Feb 13, 2010
    nifty46 likes this.
  7. jdm

    jdm Well-Known Member

    Joined:
    Jul 7, 2005
    Messages:
    863
    Likes Received:
    477
    Trophy Points:
    63
    have not tried the same so cant say for sure. best is to try linking it :)
     
    nac and nifty46 like this.
  8. yeklim

    yeklim New Member

    Joined:
    Jan 30, 2010
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    @shanky99
    how is to use/create DDE to import RT data from excel to Amibroker
    kindly share the methode please...
    tx.
     
  9. shanki99

    shanki99 Well-Known Member

    Joined:
    Aug 28, 2008
    Messages:
    689
    Likes Received:
    487
    Trophy Points:
    63
    Location:
    Chennai
    Try here....

    ht t p://w w w. in di traders.com/amibroker/2100-excel-amibroker-dde-concept-implementation.html

    remove spaces
     
  10. sub2501

    sub2501 Active Member

    Joined:
    Jun 17, 2009
    Messages:
    140
    Likes Received:
    56
    Trophy Points:
    28
    Is it possible to download intraday quotes from NSEINDIA instead of yahoo or google.
    thanks subha
     

Share This Page