7 New Messages
Digest #2925
Messages
Sun Jan 12, 2014 1:06 am (PST) . Posted by:
"Ka Yau Wong" wongkayau
Hi Randy,
Morning.
I would like to download the historical price of the following to excel:
http://www.investing.com/rates-bonds/china-10-year-bond-yield-historical-data
However, i can't find the true url behind. I have tried both firebug and Urlsnooper but no luck. Could you please kindly help?
Thank you so much!
Cheers,
Laurent
On Friday, December 6, 2013 1:28 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,
>
Morning.
I would like to download the historical price of the following to excel:
http://www.investin
However, i can't find the true url behind. I have tried both firebug and Urlsnooper but no luck. Could you please kindly help?
Thank you so much!
Cheers,
Laurent
On Friday, December 6, 2013 1:28 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,
>
Sun Jan 12, 2014 1:53 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Sorry. No luck here either. Just the initial display of data. It's appears
to be calling an AJAX process at "/instruments/HistoricalDataAjax", but I
don't see a way to intercept the results of the call to AJAX.
On Sun, Jan 12, 2014 at 2:06 AM, Ka Yau Wong <wongkayau@yahoo.com> wrote:
>
> I would like to download the historical price of the following to excel:
>
> http://www.investing.com/rates-bonds/china-10-year-bond-yield-historical-data
>
> However, i can't find the true url behind. I have tried both firebug and
> Urlsnooper but no luck. Could you please kindly help?
>
>
to be calling an AJAX process at "/instruments/
don't see a way to intercept the results of the call to AJAX.
On Sun, Jan 12, 2014 at 2:06 AM, Ka Yau Wong <wongkayau@yahoo.
>
> I would like to download the historical price of the following to excel:
>
> http://www.investin
>
> However, i can't find the true url behind. I have tried both firebug and
> Urlsnooper but no luck. Could you please kindly help?
>
>
Sun Jan 12, 2014 2:26 am (PST) . Posted by:
wongkayau
No problem. Thank you so much for your quick reponse!
Cheers
Sun Jan 12, 2014 6:41 am (PST) . Posted by:
"PC_BABE" cs.holdings
Ive found Alex's site to be very reliable and helpful
http://unicorn.us.com/advdec/
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Tuesday, January 7, 2014 6:49 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Total volume
Just array-enter this over a 3-row by 1-column range:
=RCHGetYahooQuotes("^TV.O,^TV.N,^TV.AQ <http://TV.AQ> ","l1")
On Tue, Jan 7, 2014 at 1:17 PM, Dave Charlaff <davecharlaff@hotmail.com <mailto:davecharlaff@hotmail.com> > wrote:
Yahoo provides Total Volume for the NYSE at http://finance.yahoo.com/q?s=%5ETV.o <http://finance.yahoo.com/q?s=%5ETV.o&ql=1> &ql=1. Their actual symbol is ^TV.N.
I am trying to capture Total Volume for the NTSE and the OTC (NASDAQ - ^TV.O) and the American Stock Exchange(^TV.AQ <http://TV.AQ> I think) to try and get a feel for total volume of shares traded daily.
This is not a price. What is the simplest way to get these volume stats into separate cells in my spreadsheet?
http://unicorn.
From: smf_addin@yahoogrou
Sent: Tuesday, January 7, 2014 6:49 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Total volume
Just array-enter this over a 3-row by 1-column range:
=RCHGetYahooQuotes(
On Tue, Jan 7, 2014 at 1:17 PM, Dave Charlaff <davecharlaff@
Yahoo provides Total Volume for the NYSE at http://finance.
I am trying to capture Total Volume for the NTSE and the OTC (NASDAQ - ^TV.O) and the American Stock Exchange(^TV.
This is not a price. What is the simplest way to get these volume stats into separate cells in my spreadsheet?
Sun Jan 12, 2014 7:09 am (PST) . Posted by:
mrothaus
I thought about it some more, and I am sure there is a bug in RCHGetYahooQuotes when using an array-entered formula, and the source column contains blanks. The returned results will not line up properly.
The code that currently looks like this:
Case Is >= 8192
sTickers = ""
For Each oCell In pTickers
If oCell.Value > " " Then sTickers = sTickers & oCell.Value & "+"
Next oCell
sTickers = Left(sTickers, Len(sTickers) - 1)
works better when coded like this:
Case Is >= 8192
sTickers = ""
For Each oCell In pTickers
If oCell.Value > " " Then
sTickers = sTickers & oCell.Value & "+"
Else
sTickers = sTickers & "XXXXXX+"
End If
Next oCell
sTickers = Left(sTickers, Len(sTickers) - 1)
That way when the results are parsed, the cells will line up properly. Corresponding blank source cells will show a 0 in the result cell. I haven't tested this fully in every scenario, but for my situation, it is working as expected.
Randy may have other reasons that I am not aware of not to update his code, but for others out there that are in the same situation as I am, putting in my suggested fix will help.
The code that currently looks like this:
Case Is >= 8192
sTickers = ""
For Each oCell In pTickers
If oCell.Value > " " Then sTickers = sTickers & oCell.Value & "+"
Next oCell
sTickers = Left(sTickers, Len(sTickers) - 1)
works better when coded like this:
Case Is >= 8192
sTickers = ""
For Each oCell In pTickers
If oCell.Value > " " Then
sTickers = sTickers & oCell.Value & "+"
Else
sTickers = sTickers & "XXXXXX+
End If
Next oCell
sTickers = Left(sTickers, Len(sTickers) - 1)
That way when the results are parsed, the cells will line up properly. Corresponding blank source cells will show a 0 in the result cell. I haven't tested this fully in every scenario, but for my situation, it is working as expected.
Randy may have other reasons that I am not aware of not to update his code, but for others out there that are in the same situation as I am, putting in my suggested fix will help.
Sun Jan 12, 2014 8:43 am (PST) . Posted by:
irebian
solved!
Much appreciated!
Much appreciated!
Sun Jan 12, 2014 10:44 am (PST) . Posted by:
climbermel
Randy, I've been looking at how to implement it into a database application as well. Access makes sense since it uses the same VBA as Excel, but Access isn't my database of choice.
I understand your concern and agree that it will cause problems if people want to use it to build databases of info downloaded using it. There are far better and easier ways to get volumes of data than that.
My reason for wanting to incorporate it is that I am building a portfolio app that will contain all my portfolios, all my trades and a nice front end for managing it. I can get everything I need from the SMF Addin into a simple excel spreadsheet in seconds and I do that currently. I can have Access open the spreadsheet, tell it to refresh and then read all the data I need... but I would rather the database app pull it directly the same way the spreadsheet does. In fact it would cause less load than my spreadsheet, since when I tell the sheet to calc, it does so for all tickers I have. The database would work like a one line spreadsheet just pulling the data for the ticker you are looking at. When I get it working, I'll let you know how it works.
Love the tools and all the work you have put into it. I have used it for years, but have just recently been adding more of it's capabilities to some of my spreadsheets.
Mel
I understand your concern and agree that it will cause problems if people want to use it to build databases of info downloaded using it. There are far better and easier ways to get volumes of data than that.
My reason for wanting to incorporate it is that I am building a portfolio app that will contain all my portfolios, all my trades and a nice front end for managing it. I can get everything I need from the SMF Addin into a simple excel spreadsheet in seconds and I do that currently. I can have Access open the spreadsheet, tell it to refresh and then read all the data I need... but I would rather the database app pull it directly the same way the spreadsheet does. In fact it would cause less load than my spreadsheet, since when I tell the sheet to calc, it does so for all tickers I have. The database would work like a one line spreadsheet just pulling the data for the ticker you are looking at. When I get it working, I'll let you know how it works.
Love the tools and all the work you have put into it. I have used it for years, but have just recently been adding more of it's capabilities to some of my spreadsheets.
Mel
Tidak ada komentar:
Posting Komentar