pandas data reader function for google finance can be really slow

Question

I am trying to get google finance data for stocks. However, sometimes it hangs and takes 30 seconds to a minute, and sometimes it runs in less than 5 seconds.

from pandas.io.data import DataReader
from datetime import datetime

stock = DataReader('TSLA', 'google', datetime(2010,1,1), datetime(2016,1,1))

What's the reason for this? Is there a queue for data? Do I have a limit to how many times I can call the API in a fixed time period?

Thanks!

If you more frequently than response time will increase. Usually, there are limits to how many calls you can make in minute to reduce load on server — Kush Patel, Mar 22 '16 at 05:53
Sorry, I wanted to ask how frequently did you ran API call like 10 call per min — Kush Patel, Mar 22 '16 at 20:04
I think it's my router. I tethered my iphone's internet to my computer and it downloaded significantly faster. Do you know of anything in the router that would cause it download stock data so slowly? — Bluegreen17, Mar 23 '16 at 03:21
And to answer your first question, maybe I called the API once or twice per minute for a few minutes. — Bluegreen17, Mar 23 '16 at 03:46

score 0 · Answer 1 · answered Jul 20 '17 at 06:03

0

There is a limit on the time of your request Pause three minutes and it will recover

answered Jul 20 '17 at 06:03

Zhongheng Shen

1

pandas data reader function for google finance can be really slow

1 Answers1