15 New Messages
Digest #2836
Messages
Sat Nov 2, 2013 1:38 am (PDT) . Posted by:
"Shekhar Marathe" ckppmarathe
Hello Randy,
I array entered following formula in a range of cells 8 columns wide X 11
rows tall. It gives only blank cells.
=smfGetCSVFile("
http://www.quandl.com/api/V1/datasets/NSE/INFY.csv?&rows=5&sort_order=desc")
What is wrong?
Thanks and regards,
-Shekhar
On Fri, Nov 1, 2013 at 1:02 PM, Randy Harmelink <rharmelink@gmail.com>wrote:
>
>
> I added those parameters for special uses I needed of the function,
> primarily so I could use it in VBA. I thought documenting them would cause
> more issues than not.
>
>
> On Fri, Nov 1, 2013 at 1:22 AM, Shekhar Marathe <ckppmarathe@gmail.com>wrote:
>
>>
>> The function smfGetCSVFile ha three more parameters in addition to the
>> URL. But the documentation does not describe these three. Even the
>> example file also has only the URL and it works.
>>
>>
>
>
I array entered following formula in a range of cells 8 columns wide X 11
rows tall. It gives only blank cells.
=smfGetCSVFile(
http://www.quandl.
What is wrong?
Thanks and regards,
-Shekhar
On Fri, Nov 1, 2013 at 1:02 PM, Randy Harmelink <rharmelink@gmail.
>
>
> I added those parameters for special uses I needed of the function,
> primarily so I could use it in VBA. I thought documenting them would cause
> more issues than not.
>
>
> On Fri, Nov 1, 2013 at 1:22 AM, Shekhar Marathe <ckppmarathe@
>
>>
>> The function smfGetCSVFile ha three more parameters in addition to the
>> URL. But the documentation does not describe these three. Even the
>> example file also has only the URL and it works.
>>
>>
>
>
Sat Nov 2, 2013 2:20 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I don't get a CSV file returned for that URL in my browser. I just get:
{"error":"Unknown api route."}
And I get "Error" in EXCEL for your function invocation below.
It could be that the file is CREATED on the web page where you get it from,
so it doesn't exist sitting on a server anywhere for a browser or the
add-in to open it up from.
On Sat, Nov 2, 2013 at 1:38 AM, Shekhar Marathe <ckppmarathe@gmail.com>wrote:
>
> I array entered following formula in a range of cells 8 columns wide X 11
> rows tall. It gives only blank cells.
>
> =smfGetCSVFile("
> http://www.quandl.com/api/V1/datasets/NSE/INFY.csv?&rows=5&sort_order=desc
> ")
>
> What is wrong?
>
>
{"error"
And I get "Error" in EXCEL for your function invocation below.
It could be that the file is CREATED on the web page where you get it from,
so it doesn't exist sitting on a server anywhere for a browser or the
add-in to open it up from.
On Sat, Nov 2, 2013 at 1:38 AM, Shekhar Marathe <ckppmarathe@
>
> I array entered following formula in a range of cells 8 columns wide X 11
> rows tall. It gives only blank cells.
>
> =smfGetCSVFile(
> http://www.quandl.
> ")
>
> What is wrong?
>
>
Sat Nov 2, 2013 7:43 am (PDT) . Posted by:
cats1017
Thanks for creating and supporting such a great tool! I'm having trouble getting options quotes to pull on weekends or on weekdays before the market opens - is there a specific subset of the options quote function I should be using? The "GetYahooOptions" returns errors for me...
Sat Nov 2, 2013 7:45 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
It's a weekend right now. Can you give me a specific example, so I have
something to look at?
On Sat, Nov 2, 2013 at 7:13 AM, <cats1017@yahoo.com> wrote:
>
> Thanks for creating and supporting such a great tool! I'm having trouble
> getting options quotes to pull on weekends or on weekdays before the market
> opens - is there a specific subset of the options quote function I should
> be using? The "GetYahooOptions" returns errors for me...
>
something to look at?
On Sat, Nov 2, 2013 at 7:13 AM, <cats1017@yahoo.
>
> Thanks for creating and supporting such a great tool! I'm having trouble
> getting options quotes to pull on weekends or on weekdays before the market
> opens - is there a specific subset of the options quote function I should
> be using? The "GetYahooOptio
>
Sat Nov 2, 2013 9:17 am (PDT) . Posted by:
cmertz36
I have been using a spreadsheet that gives me the current stock price for any Ticker that is requested. The command in the cell is:
=0+smfstrExtr(
My question is what command can I now use to retrieve the Current Stock price.
Thanks for your help.
Sat Nov 2, 2013 9:58 am (PDT) . Posted by:
"Michael Grames" mfgrames
Yes, I have the same problem pulling the current values for a stock indexes.
Now not working:
=IF(LEN($B19)=0,"--",0+smfstrExtr(smfGetTagContent("http://www.google.com/ig/api?stock="&smfJoin($B$19:$B$25,"&stock="),"finance",-1,"<symbol
data="""&$B19&""""),"<"&LOWER(C$18)&" data=""",""""))
I received this message:
"iGoogle was retired on November 1, 2013."
Currently not sure how to pull the data from Google. I am trying to
pull the equivalent info from Yahoo.
I have been using Yahoo (RCHGetYahooQuotes) to get stock quotes for
several years now, and find that it works very well.
Mike
On 11/2/2013 12:17 PM, cmertz36@yahoo.com wrote:
>
> I have been using a spreadsheet that gives me the current stock price
> for any Ticker that is requested. The command in the cell is:
>
> =0+smfstrExtr(RCHGetWebData("http://www.google.com/iq/api?stock=&D27,Last
> Data=",50)
>
> My question is what command can I now use to retrieve the Current
> Stock price.
>
> Thanks for your help.
>
>
Now not working:
=IF(LEN($B19)
data=""
I received this message:
"iGoogle was retired on November 1, 2013."
Currently not sure how to pull the data from Google. I am trying to
pull the equivalent info from Yahoo.
I have been using Yahoo (RCHGetYahooQuotes) to get stock quotes for
several years now, and find that it works very well.
Mike
On 11/2/2013 12:17 PM, cmertz36@yahoo.
>
> I have been using a spreadsheet that gives me the current stock price
> for any Ticker that is requested. The command in the cell is:
>
> =0+smfstrExtr(
> Data=",
>
> My question is what command can I now use to retrieve the Current
> Stock price.
>
> Thanks for your help.
>
>
Sat Nov 2, 2013 10:53 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
That isn't even a valid URL you are using in that formula??
In any case, try:
=smfConvertData(smfGetTagContent("https://www.google.com/finance?q=MMM
","span",-1,"_l"">"))
On Sat, Nov 2, 2013 at 9:17 AM, <cmertz36@yahoo.com> wrote:
> I have been using a spreadsheet that gives me the current stock price
> for any Ticker that is requested. The command in the cell is:
>
> =0+smfstrExtr(RCHGetWebData("http://www.google.com/iq/api?stock=&D27,LastData=",50)
>
> My question is what command can I now use to retrieve the Current Stock
> price.
>
In any case, try:
=smfConvertData(
","
On Sat, Nov 2, 2013 at 9:17 AM, <cmertz36@yahoo.
> I have been using a spreadsheet that gives me the current stock price
> for any Ticker that is requested. The command in the cell is:
>
> =0+smfstrExtr(
>
> My question is what command can I now use to retrieve the Current Stock
> price.
>
Sat Nov 2, 2013 12:39 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Ah. Now I recall what that URL was. I just uploaded:
RCHGetWebData-Google-API-Quotes.xls
...which has an example of getting the data from the still-existing Google
API. I couldn't find definitions for some of the fields, so I left them in
as "???".
On Sat, Nov 2, 2013 at 9:58 AM, Michael Grames <mike@grames.net> wrote:
>
> Yes, I have the same problem pulling the current values for a stock
> indexes.
>
> Now not working:
> =IF(LEN($B19)=0,"--",0+smfstrExtr(smfGetTagContent(
> "http://www.google.com/ig/api?stock="<http://www.google.com/ig/api?stock=>&smfJoin($B$19:$B$25,"&stock="),"finance",-1,"<symbol
> data="""&$B19&""""),"<"&LOWER(C$18)&" data=""",""""))
>
> I received this message:
>
> "iGoogle was retired on November 1, 2013."
>
> Currently not sure how to pull the data from Google. I am trying to pull
> the equivalent info from Yahoo.
> I have been using Yahoo (RCHGetYahooQuotes) to get stock quotes for
> several years now, and find that it works very well.
>
RCHGetWebData-
...which has an example of getting the data from the still-existing Google
API. I couldn't find definitions for some of the fields, so I left them in
as "???"
On Sat, Nov 2, 2013 at 9:58 AM, Michael Grames <mike@grames.
>
> Yes, I have the same problem pulling the current values for a stock
> indexes.
>
> Now not working:
> =IF(LEN($B19)
> "http://www.google.
> data=""
>
> I received this message:
>
> "iGoogle was retired on November 1, 2013."
>
> Currently not sure how to pull the data from Google. I am trying to pull
> the equivalent info from Yahoo.
> I have been using Yahoo (RCHGetYahooQuotes) to get stock quotes for
> several years now, and find that it works very well.
>
Sat Nov 2, 2013 12:41 pm (PDT) . Posted by:
cmertz36
Thanks for your reply. When I Paste your formula into the spreadsheet, I get the correct response for MMM. The Ticker I want the Price for is located in cell D5 in my spreadsheet. How do I incorporate this into the formula. I am very new to this and I want to thank you for being so patient.
Thanks.
---In smf_addin@yahoogroups.com, <smf_addin@yahoogroups.com> wrote:
That isn't even a valid URL you are using in that formula??
In any case, try:
=smfConvertData(smfGetTagContent("https://www.google.com/finance?q=MMM https://www.google.com/finance?q=MMM","span",-1,"_l"">"))
On Sat, Nov 2, 2013 at 9:17 AM, <cmertz36@... mailto:cmertz36@...> wrote:
I have been using a spreadsheet that gives me the current stock price for any Ticker that is requested. The command in the cell is:
=0+smfstrExtr(RCHGetWebData("http://www.google.com/iq/api?stock=&D27,Last http://www.google.com/iq/api?stock=&D27,Last Data=",50)
My question is what command can I now use to retrieve the Current Stock price.
Thanks.
---In smf_addin@yahoogrou
That isn't even a valid URL you are using in that formula??
In any case, try:
=smfConvertData(
On Sat, Nov 2, 2013 at 9:17 AM, <cmertz36@
I have been using a spreadsheet that gives me the current stock price for any Ticker that is requested. The command in the cell is:
=0+smfstrExtr(
My question is what command can I now use to retrieve the Current Stock price.
Sat Nov 2, 2013 1:08 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You just need to use normal EXCEL concatenation to combine the two strings:
"https://www.google.com/finance?q="
D5
So you'd end up with:
=smfConvertData(smfGetTagContent("https://www.google.com/finance?q=" &
D5,"span",-1,"_l"">"))
On Sat, Nov 2, 2013 at 12:41 PM, <cmertz36@yahoo.com> wrote:
> Thanks for your reply. When I Paste your formula into the spreadsheet, I
> get the correct response for MMM. The Ticker I want the Price for is
> located in cell D5 in my spreadsheet. How do I incorporate this into the
> formula. I am very new to this and I want to thank you for being so patient.
>
"https://www.
D5
So you'd end up with:
=smfConvertData(
D5,"span"
On Sat, Nov 2, 2013 at 12:41 PM, <cmertz36@yahoo.
> Thanks for your reply. When I Paste your formula into the spreadsheet, I
> get the correct response for MMM. The Ticker I want the Price for is
> located in cell D5 in my spreadsheet. How do I incorporate this into the
> formula. I am very new to this and I want to thank you for being so patient.
>
Sat Nov 2, 2013 1:16 pm (PDT) . Posted by:
cmertz36
Thanks,
I replaced the statement in all locations within the spreadsheets and everything is working.
Thanks again for all the help.
---In smf_addin@yahoogroups.com, <smf_addin@yahoogroups.com> wrote:
You just need to use normal EXCEL concatenation to combine the two strings:
"https://www.google.com/finance?q= https://www.google.com/finance?q="
D5
So you'd end up with:
=smfConvertData(smfGetTagContent("https://www.google.com/finance?q= https://www.google.com/finance?q=" & D5,"span",-1,"_l"">"))
On Sat, Nov 2, 2013 at 12:41 PM, <cmertz36@... mailto:cmertz36@...> wrote:
Thanks for your reply. When I Paste your formula into the spreadsheet, I get the correct response for MMM. The Ticker I want the Price for is located in cell D5 in my spreadsheet. How do I incorporate this into the formula. I am very new to this and I want to thank you for being so patient.
I replaced the statement in all locations within the spreadsheets and everything is working.
Thanks again for all the help.
---In smf_addin@yahoogrou
You just need to use normal EXCEL concatenation to combine the two strings:
"https://www.
D5
So you'd end up with:
=smfConvertData(
On Sat, Nov 2, 2013 at 12:41 PM, <cmertz36@
Thanks for your reply. When I Paste your formula into the spreadsheet, I get the correct response for MMM. The Ticker I want the Price for is located in cell D5 in my spreadsheet. How do I incorporate this into the formula. I am very new to this and I want to thank you for being so patient.
Sat Nov 2, 2013 10:33 am (PDT) . Posted by:
seanchristiansen
Can someone post an example of a worksheet that pulls the weekly options pricing for S&P 500 index options? Randy discussed that one likely needs to use the RCHGetTableCell() but I am unable to make much headway.
Thanks in advance!
Sean
Thanks in advance!
Sean
Sat Nov 2, 2013 1:06 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I think your best bet path is to use this to get the quotes:
=RCHGetHTMLTable("
http://finance.yahoo.com/quotes/SPX131116C01760000,SPX131116C01770000",
">Symbol",-1,"",1)
Then you can get multiple ticker symbols at one time. Then use the
VLOOKUP() on that table to extract the data you want.
I can't give you specific formulas, because the format of that table will
vary by individual, depending on whether you are logged into your Yahoo ID
or not.
Otherwise, you have to pull them a web page at a time, which would be very
slow. And Yahoo seems to be constantly changing how they display the last
traded price. But you could do something like:
=RCHGetTableCell("http://finance.yahoo.com/q?s=SPX131116C01760000
",1,">Open")
I don't know of anything on Yahoo that shows a collection of S&P 500 index
options. As far as I know, you can only get to the data if you know the
specific ticker symbols (as used by Yahoo).
On Sat, Nov 2, 2013 at 9:58 AM, <seanchristiansen@yahoo.com> wrote:
>
> Can someone post an example of a worksheet that pulls the weekly options
> pricing for S&P 500 index options? Randy discussed that one likely needs
> to use the RCHGetTableCell() but I am unable to make much headway.
>
=RCHGetHTMLTable(
http://finance.
">Symbol&qu
Then you can get multiple ticker symbols at one time. Then use the
VLOOKUP() on that table to extract the data you want.
I can't give you specific formulas, because the format of that table will
vary by individual, depending on whether you are logged into your Yahoo ID
or not.
Otherwise, you have to pull them a web page at a time, which would be very
slow. And Yahoo seems to be constantly changing how they display the last
traded price. But you could do something like:
=RCHGetTableCell(
",1,"
I don't know of anything on Yahoo that shows a collection of S&P 500 index
options. As far as I know, you can only get to the data if you know the
specific ticker symbols (as used by Yahoo).
On Sat, Nov 2, 2013 at 9:58 AM, <seanchristiansen@
>
> Can someone post an example of a worksheet that pulls the weekly options
> pricing for S&P 500 index options? Randy discussed that one likely needs
> to use the RCHGetTableCell(
>
Sat Nov 2, 2013 10:42 am (PDT) . Posted by:
kkkutty
Sorry I'm late in replying to this message...has any attempt been made to create such a database? I would be interested in creating such a database if possible starting with the extraction of basic elements. Is there anyone with XBRL expertise? If this is outside the scope of this group, I apologize.
---In smf_addin@yahoogroups.com, <smf_addin@yahoogroups.com> wrote:
So who would maintain this DB? It would need constant updating if it is to be accurate. Who would decide with elements you want to keep updated?
I think I'll stick with the SMF-Addin and pull the data when I need it. But then I am not that much of a fundamentalist.
Good luck,
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of scasty@...
Sent: Sunday, September 29, 2013 1:32 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] this lack of useful financial data is silly
I propose we create an opensource database for every public company on a major U.S. stock exchange with a market cap above $100m.
This is about 3000 stocks and ADRs. We can start with the highest market cap and work our way down to the bottom.
First we need to create a database template -- so we are all using the same financial definitions for EBITDA, EBT, etc. This template needs to be automatically updated with XBRL data and adjusted manually by people that know what they are doing.
I am not a database expert but this shouldn't be too hard. Just piggy back on whatever XBRL.org is doing and have 1- to a few people be in charge of updating and error checking data of a particular stock. Compile all the data to a single open source point -- like a wikipedia of financial data.
I don't imagine we are going to get 3000+ people right off the bat to sponsor the data integrity of 3000+ stocks and ADRs, but we should start somewhere.
---In smf_addin@yahoogrou
So who would maintain this DB? It would need constant updating if it is to be accurate. Who would decide with elements you want to keep updated?
I think I'll stick with the SMF-Addin and pull the data when I need it. But then I am not that much of a fundamentalist.
Good luck,
Kermit
From: smf_addin@yahoogrou
Sent: Sunday, September 29, 2013 1:32 PM
To: smf_addin@yahoogrou
Subject: [smf_addin] this lack of useful financial data is silly
I propose we create an opensource database for every public company on a major U.S. stock exchange with a market cap above $100m.
This is about 3000 stocks and ADRs. We can start with the highest market cap and work our way down to the bottom.
First we need to create a database template -- so we are all using the same financial definitions for EBITDA, EBT, etc. This template needs to be automatically updated with XBRL data and adjusted manually by people that know what they are doing.
I am not a database expert but this shouldn'
I don't imagine we are going to get 3000+ people right off the bat to sponsor the data integrity of 3000+ stocks and ADRs, but we should start somewhere.
Sat Nov 2, 2013 1:03 pm (PDT) . Posted by:
sdavis81
Just to document in case anyone searches, this was a Fusion issue. For Mavericks OSX you need to upgrade to Fusion 6. With Fusion 4 which I had, it isn't compatible.
Thanks for looking
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
Are you getting the #VALUE? error for new formulas as well, or just in existing workbooks? If so, you may have location errors (EXCEL hard codes the location of the add-in when it saves a workbook). Do you see any paths in front of the function names?
Since I know nothing about Macs, I'm just making a WAG.
On Thu, Oct 31, 2013 at 6:24 PM, <sdavis81@... mailto:sdavis81@...> wrote:
I have a sheet that I have used for a while in VM Fusion, using Windows XP. My old Mac was backed up using Time Machine.
I booted my new MBP with TM and everything seems fine but my sheet won't work. I am getting "?Value" for all formulas.
I can't figure out what is the matter. The files are still in the c:/Program files/SMF add-in folder. Under the Add-in tab, the stock market function tool is checked. I unchecked it, deleted all the add-in files and reinstalled fresh. Still getting the same value error. When I look under add-ins tab in excel options, I see the "active Add-ins" includes this one and is directed to the correct folder c:/program files/smf add-in.
Any thoughts? Theorectically this should be a mirror. I am not sure what else to check. I do have a PC at work and will open my sheet tomorrow (it is saved in Dropbox usually).
Thanks for looking
---In smf_addin@yahoogrou
Are you getting the #VALUE? error for new formulas as well, or just in existing workbooks? If so, you may have location errors (EXCEL hard codes the location of the add-in when it saves a workbook). Do you see any paths in front of the function names?
Since I know nothing about Macs, I'm just making a WAG.
On Thu, Oct 31, 2013 at 6:24 PM, <sdavis81@
I have a sheet that I have used for a while in VM Fusion, using Windows XP. My old Mac was backed up using Time Machine.
I booted my new MBP with TM and everything seems fine but my sheet won't work. I am getting "?Value" for all formulas.
I can't figure out what is the matter. The files are still in the c:/Program files/SMF add-in folder. Under the Add-in tab, the stock market function tool is checked. I unchecked it, deleted all the add-in files and reinstalled fresh. Still getting the same value error. When I look under add-ins tab in excel options, I see the "active Add-ins" includes this one and is directed to the correct folder c:/program files/smf add-in.
Any thoughts? Theorectically this should be a mirror. I am not sure what else to check. I do have a PC at work and will open my sheet tomorrow (it is saved in Dropbox usually).
Tidak ada komentar:
Posting Komentar