StockFetcher Forums · General Discussion · Returning Stock Data<< >>Post Follow-up
scrambled2
5 posts
msg #124576
Ignore scrambled2
8/3/2015 6:15:04 AM

I'm working with a large dataset of trades made in a backtest, and I am looking for a way to get data at specific times. For example if AAPL were the stock I had traded on a given date say May 1st 2011. I would like to be able to find out (preferrably in an EXCEL formatted data set) all sorts of data for AAPL on that date such as RSI, SMA(5),...ect. Can StockFetcher give me this data for a specific date or is there another service anyone is aware of that can perform this function? Graphs are fine, but many times don't show the specific numbers you are after and are usually not downloadable in a .csv format.

Thanks for all of your help!!

Chris

four
4,012 posts
msg #124581
Ignore four
8/3/2015 4:16:32 PM

Image and video hosting by TinyPic

scrambled2
5 posts
msg #124587
Ignore scrambled2
8/4/2015 1:37:47 AM

That is quite helpful thank you sir! I am curious how far back Stockfetcher's data goes with a reasonable degree of accuracy.

Thanks!

novacane32000
273 posts
msg #124597
Ignore novacane32000
8/4/2015 10:05:48 PM

Four--Is there a way to download data for multiple dates?

Say I wanted to see rsi(3) for AAPL from 1/1/15 through 8/4/15 ?

four
4,012 posts
msg #124598
Ignore four
modified
8/4/2015 11:05:48 PM

scrambled2

Image and video hosting by TinyPic

four
4,012 posts
msg #124599
Ignore four
modified
8/4/2015 11:14:23 PM

novacane32000

No sarcasm on my part... just trying to answer the question.
Agree, it is the hard way... I don't know of another way with StockFetcher.
Seems to limit = 20 days [ 1 month at a time ].

------
investigate:
http://www.quantshare.com/sa-143-create-a-pivot-table-that-displays-the-relative-strength-index-rsi
-------

Fetcher[
symlist(aapl)

symlist(aapl)
add column rsi(3) 1 day ago {1}
add column rsi(3) 2 days ago { 2}
add column rsi(3) 3 days ago { 3}
add column rsi(3) 4 days ago { 4}
add column rsi(3) 5 days ago { 5}
add column rsi(3) 6 days ago { 6}
add column rsi(3) 7 days ago { 7}
add column rsi(3) 8 days ago { 8}
add column rsi(3) 9 days ago { 9}
add column rsi(3) 10 days ago { 10}
add column rsi(3) 11 days ago { 11}
add column rsi(3) 12 days ago { 12}
add column rsi(3) 13 days ago { 13}
add column rsi(3) 14 days ago { 14}
add column rsi(3) 15 days ago { 15}
add column rsi(3) 16 days ago { 16}
add column rsi(3) 17 days ago { 17}
add column rsi(3) 18 days ago { 18}
add column rsi(3) 19 days ago { 19}
add column rsi(3) 20 days ago { 20}

]






StockFetcher Forums · General Discussion · Returning Stock Data<< >>Post Follow-up

*** Disclaimer *** StockFetcher.com does not endorse or suggest any of the securities which are returned in any of the searches or filters. They are provided purely for informational and research purposes. StockFetcher.com does not recommend particular securities. StockFetcher.com, Vestyl Software, L.L.C. and involved content providers shall not be liable for any errors or delays in the content, or for any actions taken based on the content.


Copyright 2016 - Vestyl Software L.L.C.Terms of Service | License | Questions or comments? Contact Us
EOD Data sources: DDFPlus & CSI Data Quotes delayed during active market hours. Delay times are at least 15 mins for NASDAQ, 20 mins for NYSE and Amex. Delayed intraday data provided by DDFPlus