15 New Messages
Digest #2885
Messages
Thu Dec 5, 2013 4:40 am (PST) . Posted by:
kcaisaacs
Randy,
I am trying to get 10 quarters of financials from Morningstar using your smfGetCSVFIle function. When I set the period to 3 for quarterly, I can only get the latest 5 quarters even though I have set the "columns" to 10. Changing this column number seems to have no effect on the output.
Thanks
Ken
I am trying to get 10 quarters of financials from Morningstar using your smfGetCSVFIle function. When I set the period to 3 for quarterly, I can only get the latest 5 quarters even though I have set the "columns" to 10. Changing this column number seems to have no effect on the output.
Thanks
Ken
Thu Dec 5, 2013 6:52 am (PST) . Posted by:
"Randy Harmelink" rharmelink
10 periods are only available if you're a member and have created the
necessary IE security cookie, by logging in with either the EXCEL Web Query
dialog (preferred) or with IE.
Otherwise, the non-member default is 5 periods.
On Thu, Dec 5, 2013 at 5:40 AM, <ken.isaacs@verizon.net> wrote:
> I am trying to get 10 quarters of financials from Morningstar using your
> smfGetCSVFIle function. When I set the period to 3 for quarterly, I can
> only get the latest 5 quarters even though I have set the "columns" to 10.
> Changing this column number seems to have no effect on the output.
>
necessary IE security cookie, by logging in with either the EXCEL Web Query
dialog (preferred) or with IE.
Otherwise, the non-member default is 5 periods.
On Thu, Dec 5, 2013 at 5:40 AM, <ken.isaacs@verizon.
> I am trying to get 10 quarters of financials from Morningstar using your
> smfGetCSVFIle function. When I set the period to 3 for quarterly, I can
> only get the latest 5 quarters even though I have set the "columns" to 10.
> Changing this column number seems to have no effect on the output.
>
Thu Dec 5, 2013 8:07 am (PST) . Posted by:
"Ka Yau Wong" wongkayau
Hi Randy,
Sorry for asking question via email. I tried posting new topic but errors pop up:
1. "Sorry, an error occurred while loading the content.
2. "Could not send the message".
Just a quick one. I would like to download data from this website:
http://data.stats.gov.cn/workspace/index?m=hgyd
However, no matter how i change my data selections, the url remains the same. How may I find the true url behind, so that I can use smf to download different data by altering the url?
Thank you so much for your help.
Cheers,
Laurent
Sorry for asking question via email. I tried posting new topic but errors pop up:
1. "Sorry, an error occurred while loading the content.
2. "Could not send the message"
Just a quick one. I would like to download data from this website:
http://data.
However, no matter how i change my data selections, the url remains the same. How may I find the true url behind, so that I can use smf to download different data by altering the url?
Thank you so much for your help.
Cheers,
Laurent
Thu Dec 5, 2013 9:23 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Some web pages, especially ASP, don't have "bookmarkable" URLs. At least
not in a way I know about, because I'm not familiar with ASP web page
coding and techniques.
However, I can use my "Web Developer" add-on for FireFox, to change HTML
forms from "Puts" to "Gets", which sometimes will reveal a "bookmarkable"
URL.
On Thu, Dec 5, 2013 at 9:04 AM, Ka Yau Wong <wongkayau@yahoo.com> wrote:
>
> Sorry for asking question via email. I tried posting new topic but errors
> pop up:
> 1. "Sorry, an error occurred while loading the content.
> 2. "Could not send the message".
>
> Just a quick one. I would like to download data from this website:
> http://data.stats.gov.cn/workspace/index?m=hgyd
>
> However, no matter how i change my data selections, the url remains the
> same. How may I find the true url behind, so that I can use smf to download
> different data by altering the url?
>
> Thank you so much for your help.
>
> Cheers,
>
not in a way I know about, because I'm not familiar with ASP web page
coding and techniques.
However, I can use my "Web Developer" add-on for FireFox, to change HTML
forms from "Puts" to "Gets"
URL.
On Thu, Dec 5, 2013 at 9:04 AM, Ka Yau Wong <wongkayau@yahoo.
>
> Sorry for asking question via email. I tried posting new topic but errors
> pop up:
> 1. "Sorry, an error occurred while loading the content.
> 2. "Could not send the message"
>
> Just a quick one. I would like to download data from this website:
> http://data.
>
> However, no matter how i change my data selections, the url remains the
> same. How may I find the true url behind, so that I can use smf to download
> different data by altering the url?
>
> Thank you so much for your help.
>
> Cheers,
>
Thu Dec 5, 2013 8:08 pm (PST) . Posted by:
"Ka Yau Wong" wongkayau
from Randy's
Some web pages, especially ASP, don't have "bookmarkable" URLs. At least not in a way I know about, because I'm not familiar with ASP web page coding and techniques.
However, I can use my "Web Developer" add-on for FireFox, to change HTML forms from "Puts" to "Gets", which sometimes will reveal a "bookmarkable" URL.
My reply:
Thank you so much. I have installed the firefox addon accordingly, and have successfullychanged the website form from "Posts" to "Gets". I still can't find any "bookmarkable" URL. May you pls give me more color on getting it? Thank you very much!!!
Cheers, Laurent
On Friday, December 6, 2013 1:23 AM, Randy Harmelink <rharmelink@gmail.com> wrote:
Some web pages, especially ASP, don't have "bookmarkable" URLs. At least not in a way I know about, because I'm not familiar with ASP web page coding and techniques.
However, I can use my "Web Developer" add-on for FireFox, to change HTML forms from "Puts" to "Gets", which sometimes will reveal a "bookmarkable" URL.
On Thu, Dec 5, 2013 at 9:04 AM, Ka Yau Wong <wongkayau@yahoo.com> wrote:
>
>Sorry for asking question via email. I tried posting new topic but errors pop up:
>1. "Sorry, an error occurred while loading the content.
>2. "Could not send the message".
>
>Just a quick one. I would like to download data from this website:
>http://data.stats.gov.cn/workspace/index?m=hgyd
>
> However, no matter how i change my data selections, the url remains the same. How may I find the true url behind, so that I can use smf to download different data by altering the url?
>
>Thank you so much for your help.
>
>Cheers,
>
Some web pages, especially ASP, don't have "bookmarkable&
However, I can use my "Web Developer" add-on for FireFox, to change HTML forms from "Puts" to "Gets"
My reply:
Thank you so much. I have installed the firefox addon accordingly, and have successfully
Cheers, Laurent
On Friday, December 6, 2013 1:23 AM, Randy Harmelink <rharmelink@gmail.
Some web pages, especially ASP, don't have "bookmarkable&
However, I can use my "Web Developer" add-on for FireFox, to change HTML forms from "Puts" to "Gets"
On Thu, Dec 5, 2013 at 9:04 AM, Ka Yau Wong <wongkayau@yahoo.
>
>Sorry for asking question via email. I tried posting new topic but errors pop up:
>1. "Sorry, an error occurred while loading the content.
>2. "Could not send the message"
>
>Just a quick one. I would like to download data from this website:
>http://data.
>
> However, no matter how i change my data selections, the url remains the same. How may I find the true url behind, so that I can use smf to download different data by altering the url?
>
>Thank you so much for your help.
>
>Cheers,
>
Thu Dec 5, 2013 8:09 pm (PST) . Posted by:
"Ka Yau Wong" wongkayau
from Randy's
Some web pages, especially ASP, don't have "bookmarkable" URLs. At least not in a way I know about, because I'm not familiar with ASP web page coding and techniques.
However, I can use my "Web Developer" add-on for FireFox, to change HTML forms from "Puts" to "Gets", which sometimes will reveal a "bookmarkable" URL.
My reply:
Thank you so much. I have installed the firefox addon accordingly, and have successfullychanged the website form from "Posts" to "Gets". I still can't find any "bookmarkable" URL. May you pls give me more color on getting it? Thank you very much!!!
Cheers, Laurent
On Friday, December 6, 2013 1:23 AM, Randy Harmelink <rharmelink@gmail.com> wrote:
Some web pages, especially ASP, don't have "bookmarkable" URLs. At least not in a way I know about, because I'm not familiar with ASP web page coding and techniques.
However, I can use my "Web Developer" add-on for FireFox, to change HTML forms from "Puts" to "Gets", which sometimes will reveal a "bookmarkable" URL.
On Thu, Dec 5, 2013 at 9:04 AM, Ka Yau Wong <wongkayau@yahoo.com> wrote:
>
>Sorry for asking question via email. I tried posting new topic but errors pop up:
>1. "Sorry, an error occurred while loading the content.
>2. "Could not send the message".
>
>Just a quick one. I would like to download data from this website:
>http://data.stats.gov.cn/workspace/index?m=hgyd
>
> However, no matter how i change my data selections, the url remains the same. How may I find the true url behind, so that I can use smf to download different data by altering the url?
>
>Thank you so much for your help.
>
>Cheers,
>
Some web pages, especially ASP, don't have "bookmarkable&
However, I can use my "Web Developer" add-on for FireFox, to change HTML forms from "Puts" to "Gets"
My reply:
Thank you so much. I have installed the firefox addon accordingly, and have successfully
Cheers, Laurent
On Friday, December 6, 2013 1:23 AM, Randy Harmelink <rharmelink@gmail.
Some web pages, especially ASP, don't have "bookmarkable&
However, I can use my "Web Developer" add-on for FireFox, to change HTML forms from "Puts" to "Gets"
On Thu, Dec 5, 2013 at 9:04 AM, Ka Yau Wong <wongkayau@yahoo.
>
>Sorry for asking question via email. I tried posting new topic but errors pop up:
>1. "Sorry, an error occurred while loading the content.
>2. "Could not send the message"
>
>Just a quick one. I would like to download data from this website:
>http://data.
>
> However, no matter how i change my data selections, the url remains the same. How may I find the true url behind, so that I can use smf to download different data by altering the url?
>
>Thank you so much for your help.
>
>Cheers,
>
Thu Dec 5, 2013 8:21 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
When you then *use* the form, the URL and its parameters should be revealed
in the address bar as you go to the requested page.
However, it doesn't always work. I would say about 50-70% of the time. Some
requests MUST be "Puts", so changing them the a "Get" doesn't work. And it
won't help on ASP pages.
On Thu, Dec 5, 2013 at 9:05 PM, Ka Yau Wong <wongkayau@yahoo.com> wrote:
> Thank you so much. I have installed the firefox addon accordingly, and
> have successfully changed the website form from "Posts" to "Gets". I still
> can't find any "bookmarkable" URL. May you pls give me more color on
> getting it? Thank you very much!!!
>
in the address bar as you go to the requested page.
However, it doesn't always work. I would say about 50-70% of the time. Some
requests MUST be "Puts"
won't help on ASP pages.
On Thu, Dec 5, 2013 at 9:05 PM, Ka Yau Wong <wongkayau@yahoo.
> Thank you so much. I have installed the firefox addon accordingly, and
> have successfully changed the website form from "Posts" to "Gets"
> can't find any "bookmarkable&
> getting it? Thank you very much!!!
>
Thu Dec 5, 2013 9:06 pm (PST) . Posted by:
"Ka Yau Wong" wongkayau
Thanks. You said it works 50-70% time. Does it work for this website?
http://data.stats.gov.cn/workspace/index?m=hgyd
I tried to "use" it after converting it from posts to gets, but the address bar remains unchanged.
Thanks a lot.
On Friday, December 6, 2013 12:21 PM, Randy Harmelink <rharmelink@gmail.com> wrote:
When you then *use* the form, the URL and its parameters should be revealed in the address bar as you go to the requested page.
However, it doesn't always work. I would say about 50-70% of the time. Some requests MUST be "Puts", so changing them the a "Get" doesn't work. And it won't help on ASP pages.
On Thu, Dec 5, 2013 at 9:05 PM, Ka Yau Wong <wongkayau@yahoo.com> wrote:
Thank you so much. I have installed the firefox addon accordingly, and have successfullychanged the website form from "Posts" to "Gets". I still can't find any "bookmarkable" URL. May you pls give me more color on getting it? Thank you very much!!!
>
http://data.
I tried to "use" it after converting it from posts to gets, but the address bar remains unchanged.
Thanks a lot.
On Friday, December 6, 2013 12:21 PM, Randy Harmelink <rharmelink@gmail.
When you then *use* the form, the URL and its parameters should be revealed in the address bar as you go to the requested page.
However, it doesn't always work. I would say about 50-70% of the time. Some requests MUST be "Puts"
On Thu, Dec 5, 2013 at 9:05 PM, Ka Yau Wong <wongkayau@yahoo.
Thank you so much. I have installed the firefox addon accordingly, and have successfully
>
Thu Dec 5, 2013 9:42 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I have no idea. I don't know what to do with the page.
Sounds like it doesn't though.
On Thu, Dec 5, 2013 at 10:02 PM, Ka Yau Wong <wongkayau@yahoo.com> wrote:
>
> Thanks. You said it works 50-70% time. Does it work for this website?
> http://data.stats.gov.cn/workspace/index?m=hgyd
>
> I tried to "use" it after converting it from posts to gets, but the
> address bar remains unchanged.
>
Sounds like it doesn't though.
On Thu, Dec 5, 2013 at 10:02 PM, Ka Yau Wong <wongkayau@yahoo.
>
> Thanks. You said it works 50-70% time. Does it work for this website?
> http://data.
>
> I tried to "use" it after converting it from posts to gets, but the
> address bar remains unchanged.
>
Thu Dec 5, 2013 9:43 pm (PST) . Posted by:
"Glenn Mitchell" gmitch86
I wonder if URL Snooper would help:
http://www.donationcoder.com/Software/Mouser/urlsnooper/
I use this to archive daily market videos but it shows all URLs that
pass through your network card.
Here are a few lines from that Chinese date site:
http://data.stats.gov.cn/workspace/index?m=hgyd
http://data.stats.gov.cn/workspace/index?a=l&m=hgyd&index=A01010101%2CA01010102%2CA01010103%2CA01010104%2CA01010105%2CA01010106%2CA01010107%2CA01010108%2CA01010109®ion=000000&time=-1%2C201210&selectId=000000&third=region
http://data.stats.gov.cn/quotas/init?dbcode=hgyd&dimension=zb&selectedCodeId=
http://data.stats.gov.cn/time/init?dbcode=hgyd&dimension=sj
--
Glenn Mitchell
On 12/5/2013 8:21 PM, Randy Harmelink wrote:
>
>
> When you then *use* the form, the URL and its parameters should be
> revealed in the address bar as you go to the requested page.
>
> However, it doesn't always work. I would say about 50-70% of the time.
> Some requests MUST be "Puts", so changing them the a "Get" doesn't work.
> And it won't help on ASP pages.
>
> On Thu, Dec 5, 2013 at 9:05 PM, Ka Yau Wong <wongkayau@yahoo.com
> <mailto:wongkayau@yahoo.com>> wrote:
>
> Thank you so much. I have installed the firefox addon accordingly,
> and have successfully changed the website form from "Posts" to
> "Gets". I still can't find any "bookmarkable" URL. May you pls give
> me more color on getting it? Thank you very much!!!
>
>
>
>
>
http://www.donation
I use this to archive daily market videos but it shows all URLs that
pass through your network card.
Here are a few lines from that Chinese date site:
http://data.
http://data.
http://data.
http://data.
--
Glenn Mitchell
On 12/5/2013 8:21 PM, Randy Harmelink wrote:
>
>
> When you then *use* the form, the URL and its parameters should be
> revealed in the address bar as you go to the requested page.
>
> However, it doesn't always work. I would say about 50-70% of the time.
> Some requests MUST be "Puts"
> And it won't help on ASP pages.
>
> On Thu, Dec 5, 2013 at 9:05 PM, Ka Yau Wong <wongkayau@yahoo.
> <mailto:wongkayau@yahoo.
>
> Thank you so much. I have installed the firefox addon accordingly,
> and have successfully changed the website form from "Posts" to
> "Gets"
> me more color on getting it? Thank you very much!!!
>
>
>
>
>
Thu Dec 5, 2013 6:02 pm (PST) . Posted by:
frederick_66
Hi,
I have just installed the add-in version RCH_Stock_Market_Functions-2.1.2012.12.29 and loaded the test file. The formula result is an error no matter which ticker symbol I use. I'm running Excel 2010 in Windows7. I have the sneaking suspicion that there's a setting somewhere blocking the formula from working. I have VBA enabled for Office. The macro setting in Excel is the default of asking me before running a macro (though I did set it to run all as a test and that didn't work). Any other basics that I haven't covered that might be my problem?
Frederick
I have just installed the add-in version RCH_Stock_Market_
Frederick
Thu Dec 5, 2013 6:09 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I have no idea what SMFAddinTest.xls is. There is no "test file"
distributed with the add-in.
The macro setting is irrelevant for add-ins.
You may get errors with some RCHGetElementNumber() elements with version
2.1.2012.12.29 files, because a lot of element definitions have changed
since then, because websites have changed their web pages. Updates for the
smf-element-*.txt files can be found in the "Works in Progress" folder.
On Thu, Dec 5, 2013 at 6:56 PM, <fhurford@gmail.com> wrote:
>
> I have just installed the add-in version
> RCH_Stock_Market_Functions-2.1.2012.12.29 and loaded the test file. The
> formula result is an error no matter which ticker symbol I use. I'm
> running Excel 2010 in Windows7. I have the sneaking suspicion that there's
> a setting somewhere blocking the formula from working. I have VBA enabled
> for Office. The macro setting in Excel is the default of asking me before
> running a macro (though I did set it to run all as a test and that didn't
> work). Any other basics that I haven't covered that might be my problem?
>
distributed with the add-in.
The macro setting is irrelevant for add-ins.
You may get errors with some RCHGetElementNumber
2.1.2012.12.
since then, because websites have changed their web pages. Updates for the
smf-element-
On Thu, Dec 5, 2013 at 6:56 PM, <fhurford@gmail.
>
> I have just installed the add-in version
> RCH_Stock_Market_
> formula result is an error no matter which ticker symbol I use. I'm
> running Excel 2010 in Windows7. I have the sneaking suspicion that there's
> a setting somewhere blocking the formula from working. I have VBA enabled
> for Office. The macro setting in Excel is the default of asking me before
> running a macro (though I did set it to run all as a test and that didn't
> work). Any other basics that I haven't covered that might be my problem?
>
Thu Dec 5, 2013 6:35 pm (PST) . Posted by:
"Frederick" frederick_66
Sorry if the test file was a red herring.
With the updated txt files, I got some results, so the add-in is
functional. It just seems to be the MSN-related elements that return
errors.
Thank you.
Randy Harmelink wrote:
> I have no idea what SMFAddinTest.xls is. There is no "test file"
> distributed with the add-in.
>
> The macro setting is irrelevant for add-ins.
>
> You may get errors with some RCHGetElementNumber() elements with
> version 2.1.2012.12.29 files, because a lot of element definitions
> have changed since then, because websites have changed their web
> pages. Updates for the smf-element-*.txt files can be found in the
> "Works in Progress" folder.
>
> On Thu, Dec 5, 2013 at 6:56 PM, <fhurford@gmail.com
> <mailto:fhurford@gmail.com>> wrote:
>
>
> I have just installed the add-in version
> RCH_Stock_Market_Functions-2.1.2012.12.29 and loaded the test
> file. The formula result is an error no matter which ticker
> symbol I use. I'm running Excel 2010 in Windows7. I have the
> sneaking suspicion that there's a setting somewhere blocking the
> formula from working. I have VBA enabled for Office. The macro
> setting in Excel is the default of asking me before running a
> macro (though I did set it to run all as a test and that didn't
> work). Any other basics that I haven't covered that might be my
> problem?
>
>
>
With the updated txt files, I got some results, so the add-in is
functional. It just seems to be the MSN-related elements that return
errors.
Thank you.
Randy Harmelink wrote:
> I have no idea what SMFAddinTest.
> distributed with the add-in.
>
> The macro setting is irrelevant for add-ins.
>
> You may get errors with some RCHGetElementNumber
> version 2.1.2012.12.
> have changed since then, because websites have changed their web
> pages. Updates for the smf-element-
> "Works in Progress" folder.
>
> On Thu, Dec 5, 2013 at 6:56 PM, <fhurford@gmail.
> <mailto:fhurford@gmail.
>
>
> I have just installed the add-in version
> RCH_Stock_Market_
> file. The formula result is an error no matter which ticker
> symbol I use. I'm running Excel 2010 in Windows7. I have the
> sneaking suspicion that there's a setting somewhere blocking the
> formula from working. I have VBA enabled for Office. The macro
> setting in Excel is the default of asking me before running a
> macro (though I did set it to run all as a test and that didn't
> work). Any other basics that I haven't covered that might be my
> problem?
>
>
>
Thu Dec 5, 2013 7:14 pm (PST) . Posted by:
"hjreed@swbell.net" hjreed@swbell.net
Rebooting help! Not sure why, but it did...
I also fixed to pull L3.
If we can make it hard, we seem to do that at times!
As always, THANK YOU for taking time to look at my questions.
I appreciate it.
I also fixed to pull L3.
If we can make it hard, we seem to do that at times!
As always, THANK YOU for taking time to look at my questions.
I appreciate it.
Tidak ada komentar:
Posting Komentar