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; Hi all, I want to get intraday live quote data of NSE stocks/Indices into excel ...


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


Reply
 
Thread Tools
  #1  
Old 26th January 2010, 02:09 PM
Member
 
Join Date: Sep 2005
Location: Hyderaabd
Posts: 1,113
Thanks: 299
Thanked 385 Times in 178 Posts
murthymsr is just really nicemurthymsr is just really nicemurthymsr is just really nicemurthymsr is just really nicemurthymsr is just really nice
Default Google finance intraday live data into Exel sheet

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 by murthymsr; 29th January 2010 at 07:22 PM.
Reply With Quote
The Following User Says Thank You to murthymsr For This Useful Post:
nac (23rd November 2010)
Sponsored Links
  #2  
Old 26th January 2010, 02:38 PM
Member
 
Join Date: Jan 2010
Posts: 7
Thanks: 0
Thanked 5 Times in 1 Post
rc.trader is on a distinguished road
Default Re: Google finance intraday live data into Exel sheet

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
Reply With Quote
The Following 5 Users Say Thank You to rc.trader For This Useful Post:
AMOL007 (6th November 2010), jagankris (31st October 2010), murthymsr (28th January 2010), nac (23rd November 2010)
  #3  
Old 2nd February 2010, 03:45 PM
Member
 
Join Date: Aug 2009
Posts: 34
Thanks: 206
Thanked 45 Times in 16 Posts
NFTRADER will become famous soon enough
Default Re: Google finance intraday live data into Exel sheet

Rc.trader
can you tell me which brokers are offering neat terminal
thanx in advance
Reply With Quote
The Following 2 Users Say Thank You to NFTRADER For This Useful Post:
nac (23rd November 2010)
  #4  
Old 2nd February 2010, 05:02 PM
jdm jdm is offline
Member
 
Join Date: Jul 2005
Posts: 863
Thanks: 52
Thanked 470 Times in 241 Posts
jdm is a glorious beacon of lightjdm is a glorious beacon of lightjdm is a glorious beacon of lightjdm is a glorious beacon of lightjdm is a glorious beacon of lightjdm is a glorious beacon of light
Default Re: Google finance intraday live data into Exel sheet

Quote:
Originally Posted by murthymsr View Post
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
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")
Reply With Quote
The Following 8 Users Say Thank You to jdm For This Useful Post:
AMOL007 (6th November 2010), BrokerJi (6th February 2010), bunny (2nd February 2010), karin_jack (13th February 2010), murthymsr (6th February 2010), nac (23rd November 2010), nifty46 (13th February 2010), shanki99 (13th February 2010)
  #5  
Old 6th February 2010, 02:47 PM
Member
 
Join Date: Sep 2005
Location: Hyderaabd
Posts: 1,113
Thanks: 299
Thanked 385 Times in 178 Posts
murthymsr is just really nicemurthymsr is just really nicemurthymsr is just really nicemurthymsr is just really nicemurthymsr is just really nice
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.
..........
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
Reply With Quote
The Following 2 Users Say Thank You to murthymsr For This Useful Post:
nac (23rd November 2010), nifty46 (13th February 2010)
  #6  
Old 13th February 2010, 01:12 PM
shanki99's Avatar
Member
 
Join Date: Aug 2008
Location: Chennai
Posts: 690
Thanks: 294
Thanked 488 Times in 281 Posts
shanki99 is a glorious beacon of lightshanki99 is a glorious beacon of lightshanki99 is a glorious beacon of lightshanki99 is a glorious beacon of lightshanki99 is a glorious beacon of light
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")

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 by shanki99; 13th February 2010 at 01:21 PM.
Reply With Quote
The Following User Says Thank You to shanki99 For This Useful Post:
nifty46 (13th February 2010)
  #7  
Old 13th February 2010, 06:31 PM
jdm jdm is offline
Member
 
Join Date: Jul 2005
Posts: 863
Thanks: 52
Thanked 470 Times in 241 Posts
jdm is a glorious beacon of lightjdm is a glorious beacon of lightjdm is a glorious beacon of lightjdm is a glorious beacon of lightjdm is a glorious beacon of lightjdm is a glorious beacon of light
Default Re: Google finance intraday live data into Exel sheet

Quote:
Originally Posted by shanki99 View Post
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??
have not tried the same so cant say for sure. best is to try linking it
Reply With Quote
The Following 2 Users Say Thank You to jdm For This Useful Post:
nac (23rd November 2010), nifty46 (13th February 2010)
  #8  
Old 16th February 2010, 08:13 PM
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

@shanky99
how is to use/create DDE to import RT data from excel to Amibroker
kindly share the methode please...
tx.
Reply With Quote
  #9  
Old 16th February 2010, 09:13 PM
shanki99's Avatar
Member
 
Join Date: Aug 2008
Location: Chennai
Posts: 690
Thanks: 294
Thanked 488 Times in 281 Posts
shanki99 is a glorious beacon of lightshanki99 is a glorious beacon of lightshanki99 is a glorious beacon of lightshanki99 is a glorious beacon of lightshanki99 is a glorious beacon of light
Default Re: Google finance intraday live data into Exel sheet

Quote:
Originally Posted by yeklim View Post
@shanky99
how is to use/create DDE to import RT data from excel to Amibroker
kindly share the methode please...
tx.
Try here....

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

remove spaces
Reply With Quote
  #10  
Old 17th February 2010, 02:18 PM
sub2501's Avatar
Member
 
Join Date: Jun 2009
Posts: 140
Thanks: 109
Thanked 56 Times in 40 Posts
sub2501 will become famous soon enough
Default Re: Google finance intraday live data into Exel sheet

Is it possible to download intraday quotes from NSEINDIA instead of yahoo or google.
thanks subha


Reply With Quote
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 08:24 AM.

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 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246