15 New Messages
Digest #2820
Messages
Mon Oct 21, 2013 3:57 am (PDT) . Posted by:
youval_marks
but it does appears that yahoo does carry forex - simply typing AUDUSD=X in, you get results on yahoo
how is that different from any other yahoo finance data?
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
Yahoo doesn't carry historical quotes on forex pairs...at least not the AUD/USD pair.
Check out this template in the files area:
RCHGetTableCell-Template-Pacific-Exchange-Rate.xls
But it can only go back about 4 years for data.
That source also produces a CSV file. For example:
http://fx.sauder.ubc.ca/cgi/fxdata?b=USD&c=AUD&rd=&fd=1&fm=1&fy=2012&ld=31&lm=12&ly=2013&y=daily&q=volume&f=csv&o= http://fx.sauder.ubc.ca/cgi/fxdata?b=USD&c=AUD&rd=&fd=1&fm=1&fy=2012&ld=31&lm=12&ly=2013&y=daily&q=volume&f=csv&o=
On Sun, Oct 20, 2013 at 11:13 PM, <youval_marks@... mailto:youval_marks@...> wrote:
how can i get forex foreign exchange fx quotes (i put all words in to make it easier to search for this post!) to work with this addin? eg i tried using =smfPricesByDates($B21,R$6) where b21="AUDUSD=X" and r6=41534 and it gives #NA
and for other currency pairs, it will give a number , but that number will not vary by date
how is that different from any other yahoo finance data?
---In smf_addin@yahoogrou
Yahoo doesn't carry historical quotes on forex pairs...at least not the AUD/USD pair.
Check out this template in the files area:
RCHGetTableCell-
But it can only go back about 4 years for data.
That source also produces a CSV file. For example:
http://fx.sauder.
On Sun, Oct 20, 2013 at 11:13 PM, <youval_marks@
how can i get forex foreign exchange fx quotes (i put all words in to make it easier to search for this post!) to work with this addin? eg i tried using =smfPricesByDates(
and for other currency pairs, it will give a number , but that number will not vary by date
Mon Oct 21, 2013 8:24 am (PDT) . Posted by:
"Daniel Russell" udelfb92
I have been trying to get historical fx data as well but Yahoo doesn't
store historical FX quotes and have had to write my own VBA function using
a few of the different sources. Some of the most accurate and easy to use
sources are:
XE.COM (allows you to pull all the quotes for one base currency)
link example:
http://www.xe.com/currencytables/?from=EUR&date=2013-10-02
X-Rates.com
Oanda.com
Hope this helps!
Danny
store historical FX quotes and have had to write my own VBA function using
a few of the different sources. Some of the most accurate and easy to use
sources are:
XE.COM (allows you to pull all the quotes for one base currency)
link example:
http://www.xe.
X-Rates.com
Oanda.com
Hope this helps!
Danny
Mon Oct 21, 2013 8:24 am (PDT) . Posted by:
udelfb92
Yahoo doesn't store the data in a table like most other tickers. Most tickers have the historical prices page (http://finance.yahoo.com/q/hp?s=KO+Historical+Prices http://finance.yahoo.com/q/hp?s=KO+Historical+Prices) but the FX pages do not have historical prices. I would think because there is no exchange and actual FX quotes differ by Prime Broker.
I have been trying to get historical fx data as well but Yahoo doesn't store historical FX quotes and have had to write my own VBA function using a few of the different sources. Some of the most accurate and easy to use sources are:
XE.COM http://xe.com/ (allows you to pull all the quotes for one base currency)
link example:
http://www.xe.com/ currencytables/?from=EUR&date= 2013-10-02 http://www.xe.com/currencytables/?from=EUR&date=2013-10-02
X-Rates.com
Oanda.com
Let me know if you want the code, I will upload the file to this group.
Danny
---In smf_addin@yahoogroups.com, <youval_marks@...> wrote:
but it does appears that yahoo does carry forex - simply typing AUDUSD=X in, you get results on yahoo
how is that different from any other yahoo finance data?
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
Yahoo doesn't carry historical quotes on forex pairs...at least not the AUD/USD pair.
Check out this template in the files area:
RCHGetTableCell-Template-Pacific-Exchange-Rate.xls
But it can only go back about 4 years for data.
That source also produces a CSV file. For example:
http://fx.sauder.ubc.ca/cgi/fxdata?b=USD&c=AUD&rd=&fd=1&fm=1&fy=2012&ld=31&lm=12&ly=2013&y=daily&q=volume&f=csv&o= http://fx.sauder.ubc.ca/cgi/fxdata?b=USD&c=AUD&rd=&fd=1&fm=1&fy=2012&ld=31&lm=12&ly=2013&y=daily&q=volume&f=csv&o=
On Sun, Oct 20, 2013 at 11:13 PM, <youval_marks@... mailto:youval_marks@...> wrote:
how can i get forex foreign exchange fx quotes (i put all words in to make it easier to search for this post!) to work with this addin? eg i tried using =smfPricesByDates($B21,R$6) where b21="AUDUSD=X" and r6=41534 and it gives #NA
and for other currency pairs, it will give a number , but that number will not vary by date
I have been trying to get historical fx data as well but Yahoo doesn't store historical FX quotes and have had to write my own VBA function using a few of the different sources. Some of the most accurate and easy to use sources are:
XE.COM http://xe.com/ (allows you to pull all the quotes for one base currency)
link example:
http://www.xe.
X-Rates.com
Oanda.com
Let me know if you want the code, I will upload the file to this group.
Danny
---In smf_addin@yahoogrou
but it does appears that yahoo does carry forex - simply typing AUDUSD=X in, you get results on yahoo
how is that different from any other yahoo finance data?
---In smf_addin@yahoogrou
Yahoo doesn't carry historical quotes on forex pairs...at least not the AUD/USD pair.
Check out this template in the files area:
RCHGetTableCell-
But it can only go back about 4 years for data.
That source also produces a CSV file. For example:
http://fx.sauder.
On Sun, Oct 20, 2013 at 11:13 PM, <youval_marks@
how can i get forex foreign exchange fx quotes (i put all words in to make it easier to search for this post!) to work with this addin? eg i tried using =smfPricesByDates(
and for other currency pairs, it will give a number , but that number will not vary by date
Mon Oct 21, 2013 8:27 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Current quotes, yes. But not historical.
If you just need current quotes, use the RCHGetYahooQuotes() function.
On Mon, Oct 21, 2013 at 3:57 AM, <youval_marks@yahoo.co.uk> wrote:
> but it does appears that yahoo does carry forex - simply typing
> AUDUSD=X in, you get results on yahoo
>
> how is that different from any other yahoo finance data?
>
If you just need current quotes, use the RCHGetYahooQuotes(
On Mon, Oct 21, 2013 at 3:57 AM, <youval_marks@
> but it does appears that yahoo does carry forex - simply typing
> AUDUSD=X in, you get results on yahoo
>
> how is that different from any other yahoo finance data?
>
Mon Oct 21, 2013 6:17 am (PDT) . Posted by:
weekeewawa
works great thanks randy
Mon Oct 21, 2013 10:38 am (PDT) . Posted by:
"Chris Ball" peggysue281
Which is the new version of the add-in we need to download where Randy
corrected all of the errors?
Thanks
corrected all of the errors?
Thanks
Mon Oct 21, 2013 10:41 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
It's the RCH_Stock_Market_Functions-2.1.2013.10.17.zip file, in the "Works
in Progress" folder.
On Mon, Oct 21, 2013 at 10:38 AM, Chris Ball <crball02@gmail.com> wrote:
>
> Which is the new version of the add-in we need to download where Randy
> corrected all of the errors?
>
>
in Progress" folder.
On Mon, Oct 21, 2013 at 10:38 AM, Chris Ball <crball02@gmail.
>
> Which is the new version of the add-in we need to download where Randy
> corrected all of the errors?
>
>
Mon Oct 21, 2013 12:40 pm (PDT) . Posted by:
"Chris Ball" peggysue281
Thanks Randy
On Mon, Oct 21, 2013 at 12:41 PM, Randy Harmelink <rharmelink@gmail.com>wrote:
> **
>
>
> It's the RCH_Stock_Market_Functions-2.1.2013.10.17.zip file, in the "Works
> in Progress" folder.
>
> On Mon, Oct 21, 2013 at 10:38 AM, Chris Ball <crball02@gmail.com> wrote:
>
>>
>> Which is the new version of the add-in we need to download where Randy
>> corrected all of the errors?
>>
>>
>
>
On Mon, Oct 21, 2013 at 12:41 PM, Randy Harmelink <rharmelink@gmail.
> **
>
>
> It's the RCH_Stock_Market_
> in Progress" folder.
>
> On Mon, Oct 21, 2013 at 10:38 AM, Chris Ball <crball02@gmail.
>
>>
>> Which is the new version of the add-in we need to download where Randy
>> corrected all of the errors?
>>
>>
>
>
Mon Oct 21, 2013 10:58 am (PDT) . Posted by:
peggysue281
Which version of the add-in is the one we need to download where Randy corrected all of the errors?
Mon Oct 21, 2013 12:42 pm (PDT) . Posted by:
paul84j
Hi Randy, I had been looking at a different company on the AdvFN site [uk region] and encountered the following message:
Newest quarter's financials are not updating correctly. Visit our beta financials http://uk.advfn.com/common/financial/NYSE/coca-cola-company-the-KO/full-financials?pm=Q to view latest financial statement.
Clicking on the <beta financials> link brought me to where the historical financial data was for that company and while I was still there there I typed in BLT in the quotes box. So I suppose to be fair to AdvFN it is beta data...
---In smf_addin@yahoogroups.com, <smf_addin@yahoogroups.com> wrote:
How did you get to that page?
If I go to uk.advfn.com http://uk.advfn.com and type BLT into the ticker symbol box, I end up here:
http://uk.advfn.com/p.php?pid=qkquote&btn=&epic=BLT&symbol= http://uk.advfn.com/p.php?pid=qkquote&btn=&epic=BLT&symbol=
...and I don't see any link to financial data. And if I click on the BLT link here:
http://uk.advfn.com/exchanges/LSE/B http://uk.advfn.com/exchanges/LSE/B
...I end up here:
http://uk.advfn.com/exchanges/LSE/bhp-billiton-BLT/share-price http://uk.advfn.com/exchanges/LSE/bhp-billiton-BLT/share-price
Also no links to financial data?
On Sun, Oct 20, 2013 at 5:05 PM, <paul84j@... mailto:paul84j@...> wrote:
Interestingly, just to check one of the companies you mentioned, I searched for BLT on the uk.advfn.com http://uk.advfn.com site and here is the URL that came up:
http://uk.advfn.com/common/financial/LSE/bhp-billiton-BLT/income-statement?pm=Q http://uk.advfn.com/common/financial/LSE/bhp-billiton-BLT/income-statement?pm=Q
BLT is the ticker for BHP Billiton on the LSE and is also the ticker for Blount International on the NYSE. Advfn is confusing the two and wrongly shows the Blount International financial data for BHP Billiton!! So yes,the financial statements are there but they are for the wrong company! What is going on with AdvFN??
Newest quarter'
Clicking on the <beta financials> link brought me to where the historical financial data was for that company and while I was still there there I typed in BLT in the quotes box. So I suppose to be fair to AdvFN it is beta data...
---In smf_addin@yahoogrou
How did you get to that page?
If I go to uk.advfn.com http://uk.advfn.
http://uk.advfn.
...and I don't see any link to financial data. And if I click on the BLT link here:
http://uk.advfn.
...I end up here:
http://uk.advfn.
Also no links to financial data?
On Sun, Oct 20, 2013 at 5:05 PM, <paul84j@
Interestingly, just to check one of the companies you mentioned, I searched for BLT on the uk.advfn.com http://uk.advfn.
http://uk.advfn.
BLT is the ticker for BHP Billiton on the LSE and is also the ticker for Blount International on the NYSE. Advfn is confusing the two and wrongly shows the Blount International financial data for BHP Billiton!! So yes,the financial statements are there but they are for the wrong company! What is going on with AdvFN??
Mon Oct 21, 2013 2:18 pm (PDT) . Posted by:
analyst101010
Thanks Randy
I think i was caught up thinking about tickers like ^GSPX, etc, and wondering if most functions could be made to play nice with that.... but yeah, for the basic indexes the ETF makes sense.
JG
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
I would suggest using the ETFs based on the indexes. Then, it's a matter of what information you need. It used to be easy to collect data from Yahoo's ETF browser, but since they changed it, getting data from it is a nightmare. Things even seem to be missing.
CNN has a solid set of data:
http://money.cnn.com/quote/etf/etf.html?symb=SPY http://money.cnn.com/quote/etf/etf.html?symb=SPY
Or you could go directly to the source:
https://www.spdrs.com/product/fund.seam?ticker=spy https://www.spdrs.com/product/fund.seam?ticker=spy
Or MarketWatch:
http://www.marketwatch.com/investing/fund/spy/profile http://www.marketwatch.com/investing/fund/spy/profile
On Fri, Oct 18, 2013 at 3:12 PM, <jfgilmore@... mailto:jfgilmore@...> wrote:
I've been crawling through the RCH index of functions... but can anyone throw me a bone and let me know where I can get benchmark metrics like YTD total return, past year total return, index yield, etc. for S&P500 vs DJIA vs. FTSE vs. others? I suppose I could use 'tickers' for the indexes but am unaware which ones will work. Any thoughts?
I think i was caught up thinking about tickers like ^GSPX, etc, and wondering if most functions could be made to play nice with that.... but yeah, for the basic indexes the ETF makes sense.
JG
---In smf_addin@yahoogrou
I would suggest using the ETFs based on the indexes. Then, it's a matter of what information you need. It used to be easy to collect data from Yahoo's ETF browser, but since they changed it, getting data from it is a nightmare. Things even seem to be missing.
CNN has a solid set of data:
http://money.
Or you could go directly to the source:
https://www.
Or MarketWatch:
http://www.marketwa
On Fri, Oct 18, 2013 at 3:12 PM, <jfgilmore@
I've been crawling through the RCH index of functions... but can anyone throw me a bone and let me know where I can get benchmark metrics like YTD total return, past year total return, index yield, etc. for S&P500 vs DJIA vs. FTSE vs. others? I suppose I could use 'tickers&#
Mon Oct 21, 2013 4:13 pm (PDT) . Posted by:
lewglenn
When I use the function to get the 50-day moving average for this mutual fund, it returns "N/A". But Yahoo certainly calculates and makes available the 50-day moving average for this fund. However the function call is only returning date for the 'Previous trade' and the 'Last trade'. Open, High, Low and 50-day SMA return "N/A". Should this be happening and what, if anything, can I do about it?
Thanks.
Thanks.
Mon Oct 21, 2013 4:51 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Well, open, high, and low don't make sense for a mutual fund, since they
only trade at the end of the day. So "N/A" would be appropriate.
And it looks to me like Yahoo doesn't compute the 50-day moving averages
for mutual funds, just for stocks and ETFs.
On Mon, Oct 21, 2013 at 4:13 PM, <lewglenn@yahoo.com> wrote:
>
> When I use the function to get the 50-day moving average for this mutual
> fund, it returns "N/A". But Yahoo certainly calculates and makes available
> the 50-day moving average for this fund. However the function call is only
> returning date for the 'Previous trade' and the 'Last trade'. Open, High,
> Low and 50-day SMA return "N/A". Should this be happening and what, if
> anything, can I do about it?
>
>
only trade at the end of the day. So "N/A" would be appropriate.
And it looks to me like Yahoo doesn't compute the 50-day moving averages
for mutual funds, just for stocks and ETFs.
On Mon, Oct 21, 2013 at 4:13 PM, <lewglenn@yahoo.
>
> When I use the function to get the 50-day moving average for this mutual
> fund, it returns "N/A"
> the 50-day moving average for this fund. However the function call is only
> returning date for the 'Previous trade' and the 'Last trade'. Open, High,
> Low and 50-day SMA return "N/A"
> anything, can I do about it?
>
>
Mon Oct 21, 2013 4:58 pm (PDT) . Posted by:
lewglenn
When I go to Yahoo! Finance and pull up FBIOX, then go to 'Charts > Interactive' I can display the price of this fund over any period I choose, and also (under Technical Indicators) the SMA over any period I choose. So Yahoo most certainly computes the 50-day moving average. The question then, is where does it store this info.
---In smf_addin@yahoogroups.com, <smf_addin@yahoogroups.com> wrote:
Well, open, high, and low don't make sense for a mutual fund, since they only trade at the end of the day. So "N/A" would be appropriate.
And it looks to me like Yahoo doesn't compute the 50-day moving averages for mutual funds, just for stocks and ETFs.
On Mon, Oct 21, 2013 at 4:13 PM, <lewglenn@... mailto:lewglenn@...> wrote:
When I use the function to get the 50-day moving average for this mutual fund, it returns "N/A". But Yahoo certainly calculates and makes available the 50-day moving average for this fund. However the function call is only returning date for the 'Previous trade' and the 'Last trade'. Open, High, Low and 50-day SMA return "N/A". Should this be happening and what, if anything, can I do about it?
---In smf_addin@yahoogrou
Well, open, high, and low don't make sense for a mutual fund, since they only trade at the end of the day. So "N/A" would be appropriate.
And it looks to me like Yahoo doesn't compute the 50-day moving averages for mutual funds, just for stocks and ETFs.
On Mon, Oct 21, 2013 at 4:13 PM, <lewglenn@
When I use the function to get the 50-day moving average for this mutual fund, it returns "N/A"
Mon Oct 21, 2013 4:56 pm (PDT) . Posted by:
stumpy_chris
I am sure this has been covered, but I can not find it anywhere - is there a way to pull Mutual Fund quotes with this add-in.
If so, how? Thanks.
If so, how? Thanks.
Tidak ada komentar:
Posting Komentar