indiTraders - Forum for the Active Indian Trader  

Go Back   indiTraders - Forum for the Active Indian Trader > Tools > Data

Data Share Data & Discuss Data Sources

GFDL
Reply
 
Bookmark and Share LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 27-09-2017, 12:28 AM
adesara's Avatar
adesara adesara is offline
Regular
 
Join Date: Mar 2010
Location: Bombay
Posts: 52
Thanks: 95
Thanked 102 Times in 36 Posts
adesara will become famous soon enoughadesara will become famous soon enough
Default Google Intraday Data downloader spreadsheet

Excel based Google intraday downloader.
upto 200 scrips
all intervals
upto 15 days download possible.
format file included in this download.

Its little slow but that helps avoiding blockage by Google site.
Stores in different files Every minute whatever is downloaded.

https://www.4shared.com/s/fTScQri4Sca
__________________
Google Intraday Data Downloader V2.1
http://www.fileconvoy.com/dfl.php?id=g5fc13903b33f44d110000118836baf3d8b0ed4 ac2ai
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
The Following 6 Users Say Thank You to adesara For This Useful Post:
  #2 (permalink)  
Old 29-09-2017, 02:48 AM
adesara's Avatar
adesara adesara is offline
Regular
 
Join Date: Mar 2010
Location: Bombay
Posts: 52
Thanks: 95
Thanked 102 Times in 36 Posts
adesara will become famous soon enoughadesara will become famous soon enough
Default

Due to some complains wrt to data missing and time stamp problems I have modified the spreadsheet to overcome the problems. Also incorporated direct saving of data for each scrip and the data sequence is in standard intraday data format eliminating need for a separate format file in AB.
It is still slow and I am working on the codes to improve it.

I have uploaded modified file and it can be downloaded from the link in the first post.
__________________
Google Intraday Data Downloader V2.1
http://www.fileconvoy.com/dfl.php?id=g5fc13903b33f44d110000118836baf3d8b0ed4 ac2ai
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
The Following 7 Users Say Thank You to adesara For This Useful Post:
  #3 (permalink)  
Old 29-09-2017, 10:47 AM
Umesh Umesh is offline
Regulars
 
Join Date: Mar 2012
Posts: 157
Thanks: 420
Thanked 270 Times in 120 Posts
Umesh will become famous soon enoughUmesh will become famous soon enoughUmesh will become famous soon enoughUmesh will become famous soon enough
Default

Thanks for this spreadsheet.
It is working like a charm.

Is it possible to substitute/replace a few symbols, that I do not want, with those that I want.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
The Following 2 Users Say Thank You to Umesh For This Useful Post:
  #4 (permalink)  
Old 29-09-2017, 02:21 PM
adesara's Avatar
adesara adesara is offline
Regular
 
Join Date: Mar 2010
Location: Bombay
Posts: 52
Thanks: 95
Thanked 102 Times in 36 Posts
adesara will become famous soon enoughadesara will become famous soon enough
Default

Of course the stocklist is editable and you may replace/delete/add as you wish as long as you don't enter more than 200 stocks.
Anything above 200 is ignored.
__________________
Google Intraday Data Downloader V2.1
http://www.fileconvoy.com/dfl.php?id=g5fc13903b33f44d110000118836baf3d8b0ed4 ac2ai
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
The Following 3 Users Say Thank You to adesara For This Useful Post:
  #5 (permalink)  
Old 01-10-2017, 05:58 PM
kkseal kkseal is offline
Hip-py
 
Join Date: Apr 2009
Posts: 4,971
Thanks: 6,550
Thanked 9,544 Times in 4,115 Posts
kkseal has a reputation beyond reputekkseal has a reputation beyond repute
kkseal has a reputation beyond reputekkseal has a reputation beyond reputekkseal has a reputation beyond reputekkseal has a reputation beyond reputekkseal has a reputation beyond reputekkseal has a reputation beyond reputekkseal has a reputation beyond reputekkseal has a reputation beyond reputekkseal has a reputation beyond reputekkseal has a reputation beyond reputekkseal has a reputation beyond reputekkseal has a reputation beyond reputekkseal has a reputation beyond repute
Default

Does this work with live data or only IEoD?
__________________
'Growth & Value are joined at the hip' - Warren buffet
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
The Following 2 Users Say Thank You to kkseal For This Useful Post:
  #6 (permalink)  
Old 01-10-2017, 08:26 PM
adesara's Avatar
adesara adesara is offline
Regular
 
Join Date: Mar 2010
Location: Bombay
Posts: 52
Thanks: 95
Thanked 102 Times in 36 Posts
adesara will become famous soon enoughadesara will become famous soon enough
Default

Originally Posted by kkseal View Post
Does this work with live data or only IEoD?

It's live data. But data is always from start of the day.

Sent from my XT1068 using Tapatalk
__________________
Google Intraday Data Downloader V2.1
http://www.fileconvoy.com/dfl.php?id=g5fc13903b33f44d110000118836baf3d8b0ed4 ac2ai
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
The Following 3 Users Say Thank You to adesara For This Useful Post:
  #7 (permalink)  
Old 02-10-2017, 01:10 AM
rmike rmike is offline
Regulars
 
Join Date: May 2010
Posts: 114
Thanks: 243
Thanked 343 Times in 108 Posts
rmike has a spectacular aura aboutrmike has a spectacular aura aboutrmike has a spectacular aura aboutrmike has a spectacular aura aboutrmike has a spectacular aura about
Default

Oy Vay!!!

Great Going!!!

Wish you'd done this sooner, would've saved me the headache of wading through reams of unfamiliar code, although am glad of ending up learning something new, in balance!!!

This will provide more of a choice to the end user with the attendant comfort of familiarity and the fact of excel being a native win app which won't have an initial env load pause!!!

Regards,
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
The Following 5 Users Say Thank You to rmike For This Useful Post:
  #8 (permalink)  
Old 02-10-2017, 02:42 AM
adesara's Avatar
adesara adesara is offline
Regular
 
Join Date: Mar 2010
Location: Bombay
Posts: 52
Thanks: 95
Thanked 102 Times in 36 Posts
adesara will become famous soon enoughadesara will become famous soon enough
Default

Originally Posted by rmike View Post
Oy Vay!!!

Great Going!!!

Wish you'd done this sooner, would've saved me the headache of wading through reams of unfamiliar code, although am glad of ending up learning something new, in balance!!!

This will provide more of a choice to the end user with the attendant comfort of familiarity and the fact of excel being a native win app which won't have an initial env load pause!!!

Regards,

Thanks for the kind word.

Let there be more options around. But frankly this is proving to be a headache for me now. Damn thing is so slow...
Been able to halve throughput so far. New spreadsheet is under test. Lets see.
__________________
Google Intraday Data Downloader V2.1
http://www.fileconvoy.com/dfl.php?id=g5fc13903b33f44d110000118836baf3d8b0ed4 ac2ai
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
The Following 4 Users Say Thank You to adesara For This Useful Post:
  #9 (permalink)  
Old 03-10-2017, 02:05 AM
rmike rmike is offline
Regulars
 
Join Date: May 2010
Posts: 114
Thanks: 243
Thanked 343 Times in 108 Posts
rmike has a spectacular aura aboutrmike has a spectacular aura aboutrmike has a spectacular aura aboutrmike has a spectacular aura aboutrmike has a spectacular aura about
Default

Halving the throughput is a remarkable feat in coding! That's literally a 100% increase in efficiency!!!

Headache or not! The experience and learning which accrues with this kinda exercise is its own reward. Am too experiencing such aches!!!

Cheerio!!!

Last edited by rmike; 03-10-2017 at 02:12 AM.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
The Following 5 Users Say Thank You to rmike For This Useful Post:
  #10 (permalink)  
Old 03-10-2017, 10:16 AM
MurAtt's Avatar
MurAtt MurAtt is offline
indicator
 
Join Date: May 2009
Location: Kolkata
Posts: 9,817
Thanks: 35,281
Thanked 25,279 Times in 8,852 Posts
MurAtt has disabled reputation
Default

Cool work bhai.
Should or rather WILL help a lot of fellow traders.
__________________
Trade the Moves, not the Target
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
The Following 3 Users Say Thank You to MurAtt For This Useful Post:
Reply

indiTraders - Forum for the Active Indian Trader > Tools > Data


Thread Tools
Display Modes

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 On
Refbacks are On


GFDL

All times are GMT +5.5. The time now is 01:14 AM.


vBulletin Copyright by vBulletin

Content Relevant URLs by vBSEO 3.3.2