Messages In This Digest (16 Messages)
- 1a.
- Problems to get data using RCHGetHTMLTable from the following link From: Henry
- 1b.
- Re: Problems to get data using RCHGetHTMLTable from the following li From: Randy Harmelink
- 2a.
- Re: Using SMF Add-in over multiple worksheets From: Ron Spruell
- 2b.
- Re: Using SMF Add-in over multiple worksheets From: Randy Harmelink
- 3a.
- SMFLite decimal separator issue for Non-US equities From: nuno.nogueira
- 3b.
- Re: SMFLite decimal separator issue for Non-US equities From: Randy Harmelink
- 4a.
- Re: RCHGetWebData-Template-Bar Chart-Quotes-Extract From: Henry
- 4b.
- Re: RCHGetWebData-Template-Bar Chart-Quotes-Extract From: Randy Harmelink
- 5a.
- Ipad From: bruceheil
- 5b.
- Re: Ipad From: Randy Harmelink
- 5c.
- Re: Ipad From: Damian Bielawski
- 5d.
- Re: Ipad From: Bruce Heil
- 5e.
- Re: Ipad From: Randy Harmelink
- 5f.
- Re: Ipad From: Bruce Heil
- 6a.
- New SMF User From: allennay
- 6b.
- Re: New SMF User From: Randy Harmelink
Messages
- 1a.
-
Problems to get data using RCHGetHTMLTable from the following link
Posted by: "Henry" hkctsui@shaw.ca henrykctsui
Sun Apr 22, 2012 5:48 am (PDT)
Hello :
I try to get the volume of a put option for a stock:TA strike price $17.00
expire June 16 2012 from Montreal exchange :
http://www.m-x.ca/nego_ cotes_in_ en.php?symbol= TA
<http://www.m-x.ca/nego_ cotes_in_ en.php?symbol= TA&instrument= TA++++120616P17
.00#cote> &instrument=TA++++120616P17. 00#cote
Using :
{=RCHGetHTMLTable("http://www.m- x.ca/nego_ cotes_in_ en.php?symbol= TA&instrume
nt=TA++++120616P17.00#cote", "Volume:" ,-1,"",1) }
The result was blank and I try using different parameters and the result is
the same.
Is there any thing that needs to be changed in order to extract data from
Montreal exchange?
Please advise
Henry
- 1b.
-
Re: Problems to get data using RCHGetHTMLTable from the following li
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Apr 22, 2012 6:26 am (PDT)
You can't use a positional parameter in the URL (i.e. "#cote"). Try just:
=RCHGetHTMLTable("
http://www.m-x.ca/nego_ cotes_in_ en.php?symbol= TA&instrument= TA++++120616P17. 00
","Volume:",-1,"",1)
On Sun, Apr 22, 2012 at 5:48 AM, Henry <hkctsui@shaw.ca > wrote:
> I try to get the volume of a put option for a stock:TA strike price
> $17.00 expire June 16 2012 from Montreal exchange :
>
>
> http://www.m-x.ca/nego_ cotes_in_ en.php?symbol= TA&instrument= TA++++120616P17. 00#cote
> ****
>
> Using :****
>
> {=RCHGetHTMLTable("
> http://www.m-x.ca/nego_ cotes_in_ en.php?symbol= TA&instrument= TA++++120616P17. 00#cote
> ","Volume:",-1,"",1)} ****
>
> The result was blank and I try using different parameters and the result
> is the same.****
>
> Is there any thing that needs to be changed in order to extract data from
> Montreal exchange?****
>
>
>
- 2a.
-
Re: Using SMF Add-in over multiple worksheets
Posted by: "Ron Spruell" hashky@yahoo.com hashky
Sun Apr 22, 2012 7:25 am (PDT)
I agree. But I have several 1 Tab spreadsheets that are for 1 Ticker Symbol. I change the Ticker Symbol, then hit Enter, then Calculate the Page (Shift-F9). The page updates the data. I don't have to wait for the SMFForceRecalculation to get all the data for all the open spreadsheets. What I don't know is if I enter the original Ticker Symbol, does it get the old data, or update data.
I use Rand() in my RCHGetYahooQuotes(), per your recommendation. That seems to force a data update.
>____________________ _________ ___
> From: Randy Harmelink <rharmelink@gmail.com >
>To: smf_addin@yahoogroups.com
>Sent: Saturday, April 21, 2012 7:59 AM
>Subject: Re: [smf_addin] Re: Using SMF Add-in over multiple worksheets
>
>
>
>For most add-in functions, <Shift-F9> is not going to update the data. It should work for RCHGetYahooQuotes() and RCHGetYahooHistory( ), but it won't work for RCHGetElementNumber (), RCHGetTableCell( ), RCHGetHTMLTable( ), smfGetOptionQuotes( ), etc.
>
>
>On Sat, Apr 21, 2012 at 4:12 AM, hashky <hashky@yahoo.com > wrote:
>
>
>>If I use multiple worksheets, I can go to the Tab and hit <Shift-F9> and recalculate just that sheet.
>>
>
>
>
> - 2b.
-
Re: Using SMF Add-in over multiple worksheets
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Apr 22, 2012 8:04 am (PDT)
For something like RCHGetTableCell(), it would just retrieve the old data.
Because it extracts data from a saved copy of the web page.
On Sun, Apr 22, 2012 at 7:25 AM, Ron Spruell <hashky@yahoo.com > wrote:
>
> What I don't know is if I enter the original Ticker Symbol, does it get
> the old data, or update data.
>
>
- 3a.
-
SMFLite decimal separator issue for Non-US equities
Posted by: "nuno.nogueira" nuno.nogueira35@gmail.com nuno.nogueira
Sun Apr 22, 2012 1:32 pm (PDT)
Hello,
Does anyone know how to fix the problem of the decimal separator of Non-US Stocks using SMFLite?
For example: 36,45 is returning 3645 using function RCHGetYahooQuotes in SMFLite.
I could change the regional settings but then I would need to do it in every PC.
Maybe we could add some code to the existing VBA to fix it?
Thanks in advance for any help.
- 3b.
-
Re: SMFLite decimal separator issue for Non-US equities
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Apr 22, 2012 1:33 pm (PDT)
Check out the related items in the "Links" area of the group.
On Sun, Apr 22, 2012 at 10:10 AM, nuno.nogueira
<nuno.nogueira35@gmail.com >wrote:
>
> Does anyone know how to fix the problem of the decimal separator of Non-US
> Stocks using SMFLite?
>
> For example: 36,45 is returning 3645 using function RCHGetYahooQuotes in
> SMFLite.
>
> I could change the regional settings but then I would need to do it in
> every PC.
>
> Maybe we could add some code to the existing VBA to fix it?
>
> Thanks in advance for any help.
>
- 4a.
-
Re: RCHGetWebData-Template-Bar Chart-Quotes-Extract
Posted by: "Henry" hkctsui@shaw.ca henrykctsui
Sun Apr 22, 2012 3:23 pm (PDT)
Hello :
I had tried the 30 minutes ,it does not retrieve any data but it works with daily ,week and monthy charts.
Is it possible to make modification to use existing template "RCHGetWebData-Template- Bar Chart-Quotes- Extract" for bar chart to work with TMA which can update the Canadian stock on 1 minutes interval .
http://tmx.quotemedia.com/charting. <http://tmx.quotemedphp?qm_page= 24203 ia.com/charting. > &qm_symbol=TAphp?qm_page= 24203&qm_ symbol=TA
Please advise
Henry
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
Sent: Sunday, April 15, 2012 3:50 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RCHGetWebData-Template- Bar Chart-Quotes- Extract
I just tried TA.TO and it worked fine for me. You're probably asking for a time period BarChart doesn't offer for Canadian stocks.
For example, when I look here for TA.TO:
http://charts.barchart. com/chart. asp?sym=TA. TO
...only 30-minute, daily, weekly, and monthly choices are available.
On Sun, Apr 15, 2012 at 2:14 PM, HenryT <hkctsui@shaw.ca > wrote:
The template seems to work fine for US stocks.
I had problems to get the quotes for Canadian stock like
TA.TO ,CU.TO ...by replacing the symbol from MMM.
Please advise
- 4b.
-
Re: RCHGetWebData-Template-Bar Chart-Quotes-Extract
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Apr 22, 2012 5:27 pm (PDT)
Hmmm. 30 minutes is listed as an option, but no chart comes up when it is
clicked on. So that's why there is no data.
Not possible to get data from the other site as far as I can see. The
reason it is available from BarChart is because they have the underlying
data for the chart in the source code of the web page. I don't know of any
other web sites that do that. They only display an image.
On Sun, Apr 22, 2012 at 3:22 PM, Henry <hkctsui@shaw.ca > wrote:
> I had tried the 30 minutes ,it does not retrieve any data but it works
> with daily ,week and monthy charts.
>
> Is it possible to make modification to use existing template
> "RCHGetWebData-Template- Bar Chart-Quotes- Extract" for bar chart to work
> with TMA which can update the Canadian stock on 1 minutes interval .****
>
> ** **
>
> http://tmx.quotemedia.com/charting. php?qm_page= 24203&qm_ symbol=TA* ***
>
>
>
- 5a.
-
Ipad
Posted by: "bruceheil" bruceheil@yahoo.com bruceheil
Sun Apr 22, 2012 5:22 pm (PDT)
Has anyone found and iPad app that can use smf_addin?
- 5b.
-
Re: Ipad
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Apr 22, 2012 5:30 pm (PDT)
I would assume it is highly unlikely, because the add-in requires several
MicroSoft Windows O/S DLL libraries. The IPad uses a completely different
operating system.
On Sun, Apr 22, 2012 at 4:36 PM, bruceheil <bruceheil@...<bruceheil@yahoo. com >
> wrote:
> Has anyone found and iPad app that can use smf_addin?
>
On Sun, Apr 22, 2012 at 4:44 PM, Bruce Heil <bruceheil@...> wrote:
> Randy, have you found an iPad app that will work with smf? I spoke to the
> Onlive guys and they said that in the future they were considering
> offering the ability to use add-in's and access external data sources but
> it will cost you monthly.
>
>
- 5c.
-
Re: Ipad
Posted by: "Damian Bielawski" dbielawski@gmail.com lkantgelbal
Sun Apr 22, 2012 5:52 pm (PDT)
This link makes it sound possible.
Sounds worth a shot.
http://m.zdnet.com/blog/ mobile-news/ onlive-desktop- full-ms-office- on-ipad-2- no-windows- required- review/6489
Hope this helps!
On Apr 22, 2012 8:30 PM, "Randy Harmelink" <rharmelink@gmail.com > wrote:
> **
>
>
> I would assume it is highly unlikely, because the add-in requires several
> MicroSoft Windows O/S DLL libraries. The IPad uses a completely different
> operating system.
>
> On Sun, Apr 22, 2012 at 4:36 PM, bruceheil <bruceheil@...<bruceheil@yahoo. com >
> > wrote:
>
>> Has anyone found and iPad app that can use smf_addin?
>>
>
> On Sun, Apr 22, 2012 at 4:44 PM, Bruce Heil <bruceheil@...> wrote:
>
>> Randy, have you found an iPad app that will work with smf? I spoke to the
>> Onlive guys and they said that in the future they were considering
>> offering the ability to use add-in's and access external data sources but
>> it will cost you monthly.
>>
>>
>
>
- 5d.
-
Re: Ipad
Posted by: "Bruce Heil" bruceheil@yahoo.com bruceheil
Sun Apr 22, 2012 7:13 pm (PDT)
Have you seen or used OnLive (http://desktop.onlive.com/ )? If I could get them to put smf on the server that lets you access excel and I knew the location and pointed smf to it would it work?
_____________________ _________ __
From: Randy Harmelink <rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Sunday, April 22, 2012 6:30 PM
Subject: Re: [smf_addin] Ipad
I would assume it is highly unlikely, because the add-in requires several MicroSoft Windows O/S DLL libraries. The IPad uses a completely different operating system.
On Sun, Apr 22, 2012 at 4:36 PM, bruceheil <bruceheil@...> wrote:
Has anyone found and iPad app that can use smf_addin?
>
On Sun, Apr 22, 2012 at 4:44 PM, Bruce Heil <bruceheil@...> wrote:
Randy, have you found an iPad app that will work with smf? I spoke to the Onlive guys and they said that in the future they were considering offering the ability to use
add-in's and access external data sources but it will cost you monthly.
>
- 5e.
-
Re: Ipad
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Apr 22, 2012 7:20 pm (PDT)
No idea. But it would have to have the MicroSoft Windows DLL libraries
available...
On Sun, Apr 22, 2012 at 7:13 PM, Bruce Heil <bruceheil@yahoo.com > wrote:
>
> Have you seen or used OnLive (http://desktop.onlive.com/ )? If I could get
> them to put smf on the server that lets you access excel and I knew the
> location and pointed smf to it would it work?
>
- 5f.
-
Re: Ipad
Posted by: "Bruce Heil" bruceheil@yahoo.com bruceheil
Sun Apr 22, 2012 7:31 pm (PDT)
OK, i'll work on it and post the out come here.
_____________________ _________ __
From: Randy Harmelink <rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Sunday, April 22, 2012 8:20 PM
Subject: Re: [smf_addin] Ipad
No idea. But it would have to have the MicroSoft Windows DLL libraries available...
On Sun, Apr 22, 2012 at 7:13 PM, Bruce Heil <bruceheil@yahoo.com > wrote:
>
>Have you seen or used OnLive (http://desktop.onlive.com/ )? If I could get them to put smf on the server that lets you access excel and I knew the location and pointed smf to it would it work?
>
- 6a.
-
New SMF User
Posted by: "allennay" allennay@gmail.com allennay
Sun Apr 22, 2012 5:53 pm (PDT)
Can anyone direct me to the best basic table to start learning the structure and interface of this addin? I've been doing a bit of my own analysis via Excel but can't even get close to what is going on here! However, being a total rookie, I just don't know where to start. I think I'm downloaded the necessary data to get started but I'm not sure.
- 6b.
-
Re: New SMF User
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Apr 22, 2012 5:57 pm (PDT)
There's really no structure or interface of the add-in. It's primarily a
collection of user-defined functions.
What I would suggest is going through the function documentation (folder
"Documentation" in the files area of the group) and going over the examples
for each, seeing why they work (or don't work -- some have date sensitive
items that would need to be changed) and what they are doing.
On Sun, Apr 22, 2012 at 5:45 PM, allennay <allennay@gmail.com > wrote:
> Can anyone direct me to the best basic table to start learning the
> structure and interface of this addin? I've been doing a bit of my own
> analysis via Excel but can't even get close to what is going on here!
> However, being a total rookie, I just don't know where to start. I think
> I'm downloaded the necessary data to get started but I'm not sure.
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Tidak ada komentar:
Posting Komentar