Traderji.com - Discussion forum for Stocks Commodities & Forex


Google finance intraday live data into Exel sheet

Discuss Google finance intraday live data into Exel sheet at the Intraday within the Traderji.com - Discussion forum for Stocks Commodities & Forex; Originally Posted by shanki99 Try here.... ht t p://w w w. in di traders.com/amibroker/2100-excel-amibroker-dde-concept-implementation.html remove ...


Go Back   Traderji.com - Discussion forum for Stocks Commodities & Forex > TOOLS & RESOURCES > Data Feeds > Intraday


Reply
 
Thread Tools
  #11  
Old 18th February 2010, 05:14 AM
Member
 
Join Date: Jan 2010
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
yeklim is on a distinguished road
Default Re: Google finance intraday live data into Exel sheet

Quote:
Originally Posted by shanki99 View Post
Try here....

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

remove spaces
Thanks Sir...



Reply With Quote
Sponsored Links
  #12  
Old 18th February 2010, 07:30 AM
Member
 
Join Date: Dec 2009
Location: bangalore
Posts: 282
Thanks: 92
Thanked 148 Times in 94 Posts
Aloakdutt has a spectacular aura aboutAloakdutt has a spectacular aura about
Default Re: Google finance intraday live data into Exel sheet

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
Reply With Quote
The Following User Says Thank You to Aloakdutt For This Useful Post:
nac (23rd November 2010)
  #13  
Old 22nd February 2010, 12:16 PM
alroyraj's Avatar
Member
 
Join Date: Sep 2006
Location: Bangalore
Posts: 1,385
Thanks: 2,714
Thanked 1,955 Times in 625 Posts
alroyraj has a brilliant futurealroyraj has a brilliant futurealroyraj has a brilliant futurealroyraj has a brilliant futurealroyraj has a brilliant futurealroyraj has a brilliant futurealroyraj has a brilliant futurealroyraj has a brilliant futurealroyraj has a brilliant futurealroyraj has a brilliant futurealroyraj has a brilliant futurealroyraj has a brilliant future
Default Re: Google finance intraday live data into Exel sheet

Quote:
Originally Posted by jdm View Post
murthy,
you can get the google quotes in google spreadsheet very easily. heres a sample

http://spreadsheets.google.com/ccc?k...PeDAwZ0E&hl=en

this will get the quotes for google

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

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

prev close
=googlefinance("goog","closeyest")
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 by alroyraj; 22nd February 2010 at 12:24 PM.
Reply With Quote
The Following 5 Users Say Thank You to alroyraj For This Useful Post:
karin_jack (29th March 2010), murthymsr (22nd February 2010), nac (23rd November 2010), nifty46 (2nd May 2010), shanki99 (22nd February 2010)
  #14  
Old 14th March 2010, 05:56 PM
Best of Luck's Avatar
Member
 
Join Date: Mar 2010
Posts: 79
Thanks: 55
Thanked 38 Times in 26 Posts
Best of Luck will become famous soon enough
Default Re: Google finance intraday live data into Exel sheet

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
Reply With Quote
The Following User Says Thank You to Best of Luck For This Useful Post:
nac (23rd November 2010)
  #15  
Old 19th June 2010, 07:26 PM
vssoma's Avatar
Member
 
Join Date: Aug 2009
Location: Nizamabad, Telangana
Posts: 1,671
Thanks: 1,015
Thanked 1,202 Times in 676 Posts
vssoma has much to be proud ofvssoma has much to be proud ofvssoma has much to be proud ofvssoma has much to be proud ofvssoma has much to be proud ofvssoma has much to be proud ofvssoma has much to be proud ofvssoma has much to be proud ofvssoma has much to be proud of
Default Re: Google finance intraday live data into Exel sheet

Quote:
Originally Posted by vegadigitalco View Post
dear,
i am receving this message when i click on this link.
We're sorry, svsaug6@gmail.com does not have permission to access this spreadsheet.
can you please, give me permission.
tnx,
Reply With Quote
The Following User Says Thank You to vssoma For This Useful Post:
nac (23rd November 2010)
  #16  
Old 20th June 2010, 06:10 PM
vssoma's Avatar
Member
 
Join Date: Aug 2009
Location: Nizamabad, Telangana
Posts: 1,671
Thanks: 1,015
Thanked 1,202 Times in 676 Posts
vssoma has much to be proud ofvssoma has much to be proud ofvssoma has much to be proud ofvssoma has much to be proud ofvssoma has much to be proud ofvssoma has much to be proud ofvssoma has much to be proud ofvssoma has much to be proud ofvssoma has much to be proud of
Default Re: Google finance intraday live data into Exel sheet

Quote:
Originally Posted by vegadigitalco View Post
HELLO TO ALL FRIENDS

many friend trying to download google live quote FNO sheet

so i am uploading file here, u can DOWNLOAD from here

In this SHEET u can also c PIVOT level for Nifty & Stocks

Just EDIT nifty word with another Script CODE

REGARDS
dear,
how to make refresh.....
Reply With Quote
The Following User Says Thank You to vssoma For This Useful Post:
nac (23rd November 2010)
  #17  
Old 28th June 2010, 07:58 PM
rebeck10's Avatar
Member
 
Join Date: Aug 2009
Posts: 86
Thanks: 18
Thanked 50 Times in 32 Posts
rebeck10 will become famous soon enough
Default Re: Google finance intraday live data into Exel sheet

Quote:
Originally Posted by vegadigitalco View Post
HELLO TO ALL FRIENDS

many friend trying to download google live quote FNO sheet

so i am uploading file here, u can DOWNLOAD from here

In this SHEET u can also c PIVOT level for Nifty & Stocks

Just EDIT nifty word with another Script CODE

REGARDS
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/getpri...&f=d,o,h,l,c,v
where q =stock name
i=time interval

Last edited by rebeck10; 28th June 2010 at 08:01 PM. Reason: update
Reply With Quote
The Following User Says Thank You to rebeck10 For This Useful Post:
nac (23rd November 2010)
  #18  
Old 7th July 2010, 04:46 PM
darkstar
Guest
 
Posts: n/a
Default Re: Google finance intraday live data into Exel sheet

Quote:
Originally Posted by rc.trader View Post
HI

why to get live data in exel form from google or yahoo or esignal or roguters?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
pls provide brokers name for neat terminal i only know sharebazzarinfo
thanks
Reply With Quote
The Following User Says Thank You to For This Useful Post:
nac (23rd November 2010)
  #19  
Old 7th July 2010, 05:24 PM
Member
 
Join Date: Jun 2009
Location: Chandigarh
Posts: 182
Thanks: 25
Thanked 89 Times in 48 Posts
ravinder_1215 will become famous soon enough
Default Re: Google finance intraday live data into Exel sheet

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 by ravinder_1215; 3rd September 2010 at 11:22 PM.
Reply With Quote
The Following 4 Users Say Thank You to ravinder_1215 For This Useful Post:
nac (23rd November 2010), narritu (30th October 2010), nifty46 (3rd September 2010), sam_u6 (9th July 2010)
  #20  
Old 30th October 2010, 11:12 AM
Member
 
Join Date: Aug 2010
Posts: 18
Thanks: 100
Thanked 5 Times in 5 Posts
narritu is on a distinguished road
Default Re: Google finance intraday live data into Exel sheet

Quote:
Originally Posted by ravinder_1215 View Post
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.
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


Reply With Quote
The Following User Says Thank You to narritu For This Useful Post:
nac (23rd November 2010)
Reply

Bookmarks


Advertise Here


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off



All times are GMT +5.5. The time now is 01:32 PM.

Indemnity, Disclaimer & Disclosure Notice:
By visiting Traderji.com you automatically indicate that you agree to our Forum Rules, Indemnity, Disclaimer & Disclosure Notice and General Content Disclaimer Notice and indemnify Traderji.com, its associates and related parties of all claims howsoever resulting from the usage of the forum/site.
Disclaimer: Trading or investing in stocks & commodities is a high risk activity. Any action you choose to take in the markets is totally your own responsibility. You are recommended to make appropriate enquiries and seek appropriate advise before sending money, incurring any expenses, acting on recommendations or entering into any commitment in relation to any advertisement published here. Traderji.com does not vouch for any claims made by the advertisers of products and services. Traderji.com will not be held liable for any consequences in the event such claims are not honoured by the advertisers. Traderji.com will not be liable for any, direct or indirect, consequential or incidental damages or loss arising out of the use of any information by anybody mentioned anywhere on this site.
Disclosure: The information in this forum is neither an offer to sell nor solicitation to buy any of the securities mentioned herein. The writers may or may not be trading in the securities mentioned.
All names or products mentioned are trademarks or registered trademarks of their respective owners.
General Content Disclaimer Notice:
In light of our policy of encouraging candid, open exchanges of views and the rapid distribution of information originating from many sources, Traderji.com cannot determine the accuracy or legality of any information that may be uploaded to the forum. Opinions, advice and all other information expressed by participants in discussions are those of the author. You rely on such information at your own risk. You are urged to seek professional advice for specific, individual situations and not rely solely on advice or opinions given in the discussions. Since Traderji.com is an open and free discussion forum, any comments made by members of this forum in their posts reflect their own views and not of the owner or administrator of Traderji.com. Thus the owner/administrator indemnify themselves of all claims whatsoever and will not be liable or responsible for any members comments/views in this forum Traderji.com. Although we constantly delete all irrelevant content and/or SPAM, if you should find any objectionable or offensive posts made by members of this forum which you would like to bring to our notice for removal then please Contact Us.
 


Copyright © www.Traderji.com 2001 - , All rights reserved.

Recommended Websites - www.TradersEdgeIndia.com - www.TradingPicks.com - www.MasterOfTrading.com

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70