Hello All, How can i extract 1-min , 2-min trading data of a given scrip from any of these add-ins or other URLs or tools. Eg: Say there is a scrip ABC CORP,...
12399
Randy Harmelink
rharmelink
Dec 1, 2010 10:45 am
First, you need a source of the data. Then it's a matter of seeing whether the add-in can extract the data from that source. barchart.com goes down to 5-minute...
12400
kishoremarodia
Dec 1, 2010 1:10 pm
Do you know any such sources in yahooo or google,etc?...
12401
Gary Funck
garyfunck
Dec 1, 2010 3:06 pm
First, try array entering the following in a three column field: =TRANSPOSE(RCHGetYahooHistory("XOM",2010,10,1,2010,12,31,"m","A",0,0,1,3,1)) This will return...
12402
siyehpiper
Dec 1, 2010 3:39 pm
I am sure this is a simple fix, but if offline, my data is gone. Why?...
12403
Randy Harmelink
rharmelink
Dec 1, 2010 3:43 pm
Neither carries historical data less than daily. I don't know of a source. Quite frankly, if you need data at that level, you should probably be going with...
12404
Randy Harmelink
rharmelink
Dec 1, 2010 3:52 pm
Your results are consistent with the way Yahoo provides the data in the CSV file: ...
12405
Randy Harmelink
rharmelink
Dec 1, 2010 3:53 pm
Because when it calculates the formulas, there is no data to be retrieved from the Internet if you are offline. You'd need to convert all of your data to...
12406
Gary Funck
garyfunck
Dec 1, 2010 4:01 pm
... It is interesting that 'day=1' works for months (like August, 2010) where the day of the month for the first trading is not '1'. I'll use day=1 to fetch...
12407
jcarlosd
Dec 1, 2010 7:40 pm
I am new to this group that I found browsing through the web. I am very surprised for this super tool, so congratulations to Randy and also to all the people...
12408
m.lowhead
Dec 1, 2010 9:11 pm
Hi, Most likely I´m doing something stupid or my expectations is way off. But once installed it seems there is nothing... steps I took: 1. downloaded the SMF...
12409
Randy Harmelink
rharmelink
Dec 1, 2010 9:17 pm
For most, you can get the components from Yahoo via a page like: http://finance.yahoo.com/q/cp?s=^N100 ...but you may have to retrieve multiple pages since...
12410
Randy Harmelink
rharmelink
Dec 1, 2010 9:20 pm
The only evidence you'll see of the add-in is that it should be listed on the list of add-ins in the add-in manager. Otherwise, the add-in is primarily just a...
12411
Philip S
philip_r_small
Dec 1, 2010 9:53 pm
Am looking to use SMF addin with UK stocks. Have tried to get individual data items with GetTablecell but was wondering if anyone had set up data definitions...
12412
Randy Harmelink
rharmelink
Dec 1, 2010 11:06 pm
Have you tried AdvFn? I think it would just be a matter of using their specific ticker symbols......
12413
jcarlosd
Dec 2, 2010 8:03 am
You are right, Randy, some of those indexes can be retrieved in that page. The ones missing are: FTSE-350 (^FTLC) and Madrid (^SMSI) that show no components...
12414
Randy Harmelink
rharmelink
Dec 2, 2010 8:51 am
Let me walk you through one example and you can see if you can apply it to the others. Your NMX link has 18 pages, so you need to retrieve data from those 18 ...
12415
jcarlosd
Dec 2, 2010 4:06 pm
If you use an European version of Yahoo web, you can get the ISIN-Ticker and Ticker-ISIN conversion. finance.yahoo.com does not include the ISIN in their...
12416
jcarlosd
Dec 2, 2010 4:34 pm
Thanks for your answer because it gave me an idea of how to use this great tool. I have to research more on the ISIN issue, because it is important for the...
12417
prosuite2000i
Dec 2, 2010 5:43 pm
... You can do bulk conversions from RIC to ISIN using RCHGetYahooQuotes. Bulk conversion upto 200 Tickers per request. To do so, you must use one of these...
12418
Vivek Naik
vivek.naik04
Dec 2, 2010 5:48 pm
yes i need the daily historical prices of crude oil for 15Â year thanksvivek ... From: g3blv <mikael@...> Subject: [smf_addin] Historical prices for...
12419
Randy Harmelink
rharmelink
Dec 2, 2010 5:53 pm
The problem is that the InternetExplorer object isn't a reliable method when you talk about the various permutations of different versions of IE and EXCEL. I...
12420
Gary Funck
garyfunck
Dec 2, 2010 6:16 pm
... Try this: http://www.eia.doe.gov/dnav/pet/pet_pri_spt_s1_d.htm click "Download Series History" (or "View History" in the rightmost column). It will import...
12421
David Friedman
texfriedman
Dec 2, 2010 9:30 pm
I am interested in creating and using a simple Excel spreadsheet that will allow me to see pricing data from Yahoo Finance or some other free website for...
12422
Randy Harmelink
rharmelink
Dec 2, 2010 9:56 pm
As far as I know, the add-in won't work for Macs, not unless you're running in some kind of Windows emulation partition. But I know almost nothing about Macs....
12423
David Friedman
texfriedman
Dec 2, 2010 10:06 pm
Randy, If I use Excel in a Windows partition as you suggest, how do I get your add in? Best regards, David E. Friedman cell 512.673.3193 email...
12424
Randy Harmelink
rharmelink
Dec 2, 2010 10:53 pm
It's in the files area. As is documentation....
12425
siyehpiper
Dec 2, 2010 11:38 pm
Randy: Thank You. If I copy and paste the data over the same cells in the same book, does that casue the sheet to become static, and will the smf addin cease...
12426
Randy Harmelink
rharmelink
Dec 2, 2010 11:52 pm
If you want to keep the add-in formulas intact, you'll need to cut and paste as values to another worksheet. You may want to look at the smfUpdateDownloadTable...
12427
SundermanJ
Dec 3, 2010 2:01 am
Anyone else having problems (ie Error) with element # 848?...
