Google finance intraday live data into Exel sheet

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

  1. yeklim

    yeklim New Member

    Joined:
    Jan 30, 2010
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Thanks Sir...
    :thumb:
     
  2. Aloakdutt

    Aloakdutt Active Member

    Joined:
    Dec 13, 2009
    Messages:
    296
    Likes Received:
    149
    Trophy Points:
    43
    Location:
    bangalore
    Hello Members,

    For those interested and not able to switch on TV or do not have TV to keep update on markets .

    This can be viewed now on your Computer. called MTTV.

    Here is the link for live tv from Moneycontrol.
    http://www.moneycontrol.com/tv/index.php (Copy& Paste)

    Thanks
    Alok Urs
     
    nac likes this.
  3. alroyraj

    alroyraj Well-Known Member

    Joined:
    Sep 27, 2006
    Messages:
    1,522
    Likes Received:
    2,034
    Trophy Points:
    113
    Location:
    Bangalore
    The following types of market data are currently available:

    * price: market price of the stock - delayed by up to 20 minutes.
    * priceopen: the opening price of the stock for the current day.
    * high: the highest price the stock traded for the current day.
    * low: the lowest price the stock traded for the current day.
    * volume: number of shares traded of this stock for the current day.
    * marketcap: the market cap of the stock.
    * tradetime: the last time the stock traded.
    * datadelay: the delay in the data presented for this stock using the googleFinance() function.
    * volumeavg: the average volume for this stock.
    * pe: the Price-to-Earnings ratio for this stock.
    * eps: the earnings-per-share for this stock.
    * high52: the 52-week high for this stock.
    * low52: the 52-week low for this stock.
    * change: the change in the price of this stock since yesterday's market close.
    * beta: the beta value of this stock.
    * changepct: the percentage change in the price of this stock since yesterday's close.
    * closeyest: yesterday's closing price of this stock.
    * shares: the number of shares outstanding of this stock.
    * currency: the currency in which this stock is traded.
     
    Last edited: Feb 22, 2010
    nac, nifty46, karin_jack and 2 others like this.
  4. Best of Luck

    Best of Luck Member

    Joined:
    Mar 14, 2010
    Messages:
    79
    Likes Received:
    39
    Trophy Points:
    18
    Dear Senior Members,
    Please explain how to load that Google real time data into Metastock and make it refreshes automatically .
    Is it possible to use Openoffice Calci instead of Excel ?
    If possible explain with screen shots please,
    Thanks.
    Best of Luck
     
    nac likes this.
  5. vssoma

    vssoma Well-Known Member

    Joined:
    Aug 8, 2009
    Messages:
    1,730
    Likes Received:
    1,302
    Trophy Points:
    113
    Location:
    Nizamabad, Telangana
    nac likes this.
  6. vssoma

    vssoma Well-Known Member

    Joined:
    Aug 8, 2009
    Messages:
    1,730
    Likes Received:
    1,302
    Trophy Points:
    113
    Location:
    Nizamabad, Telangana
    dear,
    how to make refresh.....
     
    nac likes this.

  7. rebeck10

    rebeck10 Member

    Joined:
    Aug 17, 2009
    Messages:
    86
    Likes Received:
    50
    Trophy Points:
    18
    how do u refresh and ge real data ,u have just given an excel file .Plz dont post rubbish
    This is the closed i have come 1 min intraday backfill on google
    http://www.google.com/finance/getprices?q=IBM&i=60&p=10d&f=d,o,h,l,c,v
    where q =stock name
    i=time interval
     
    Last edited: Jun 28, 2010
    nac likes this.
  8. darkstar

    darkstar Guest

    pls provide brokers name for neat terminal i only know sharebazzarinfo
    thanks
     
    nac likes this.
  9. ravinder_1215

    ravinder_1215 Active Member

    Joined:
    Jun 3, 2009
    Messages:
    182
    Likes Received:
    89
    Trophy Points:
    28
    Location:
    Chandigarh
    Hi friends!

    Please open attached excel sheet. There is example of downloading data from nseindia.com. It automatically refreshes data after every one minute.

    PLEASE NOTE IF U WANT TO UPDATE PIVOTS FOR NEXT DAY THEN SIMPLY CLICK ON PIVOT BUTTON AT EOD ONLY. NEXT DAY PIVOT WILL BE READY.

    DATA IS DELAYED BY 5 MINUTES APPROX.
     
    Last edited: Sep 3, 2010
    nac, narritu, nifty46 and 1 other person like this.
  10. narritu

    narritu New Member

    Joined:
    Aug 1, 2010
    Messages:
    18
    Likes Received:
    5
    Trophy Points:
    3
    Hi Ravinder,

    I could not find any attachment to your post. Can you or any other member of traderji re-post the attachment or mail me at narritu@g m a i l.c o m.

    Thanks & Regards
    narritu
     
    nac likes this.
Loading...

Share This Page