8 Messages
Digest #4255
Messages
Sun Dec 3, 2017 7:44 pm (PST) . Posted by:
holmberg_tommy
Hi,
What I have to fill in order to obtain for instance CAN/EUR exchange rate from FTs' currency cross rate table (https://markets.ft.com/data/currencies)?
What I have to fill in order to obtain for instance CAN/EUR exchange rate from FTs' currency cross rate table (https://markets.ft.com/data/currencies)?
Sun Dec 3, 2017 8:20 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Just use the smfGetYahooPortfolioView() function, using "CADEUR=X" as the
ticker symbol.
I'm not sure if the positions on the FT page can be relied upon, but this
appears to work:
=RCHGetTableCell("https://markets.ft.com/data/currencies",2,">Canada")
On Sun, Dec 3, 2017 at 8:44 PM, holmberg_tommy@
...
wrote:
> What I have to fill in order to obtain for instance CAN/EUR exchange rate
> from FTs' currency cross rate table (
> <https://markets.ft.com/data/currencies>
> <https://markets.ft.com/data/currencies>
> https://markets.ft.com/data/currencies)?
>
>
>
ticker symbol.
I'm not sure if the positions on the FT page can be relied upon, but this
appears to work:
=RCHGetTableCell("https://markets.ft.com/data/currencies",2,">Canada")
On Sun, Dec 3, 2017 at 8:44 PM, holmberg_tommy@
...
wrote:
> What I have to fill in order to obtain for instance CAN/EUR exchange rate
> from FTs' currency cross rate table (
> <https://markets.ft.com/data/currencies>
> <https://markets.ft.com/data/currencies>
> https://markets.ft.com/data/currencies)?
>
>
>
Mon Dec 4, 2017 12:26 pm (PST) . Posted by:
myriad58
Hi Randy:
I have switched over to the smfGetYahooPortfolioView add-in and I am having trouble with currency exchange. I have this function which writes the current USD/CAN exchange rate to be used to re-calculate my USD stocks into CDN $ values: dRate = smfGetYahooPortfolioView(Range("h5").Value & Range("h6").Value & "=X", , "1"). Unfortunately it returns no data! What am I doing wrong? I would ultimately like the variable dRate to hold the exchange value like it used to do with the now deprecated =RCHGetYahooQuotes add-in.
I have switched over to the smfGetYahooPortfoli
Mon Dec 4, 2017 1:31 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Your first parameter is OK, but nothing after that. What is the "1"
parameter?
I'm assuming you want:
dRate = smfGetYahooPortfolioView(Range("h5").Value & Range("h6").Value &
"=X","15") (1,1)
The "(1,1)" is necessary because the function returns an array of values
and you just want the data from the first row and column.
On Mon, Dec 4, 2017 at 1:26 PM, myriad58@
...
wrote:
>
> I have switched over to the smfGetYahooPortfolioView add-in and I am
> having trouble with currency exchange. I have this function which writes
> the current USD/CAN exchange rate to be used to re-calculate my USD stocks
> into CDN $ values:
>
> dRate = smfGetYahooPortfolioView(Range("h5").Value & Range("h6").Value &
> "=X", , "1"). Unfortunately it returns no data! What am I doing wrong? I
> would ultimately like the variable dRate to hold the exchange value like it
> used to do with the now deprecated =RCHGetYahooQuotes add-in.
>
parameter?
I'm assuming you want:
dRate = smfGetYahooPortfoli
"=X"
The "(1,1)" is necessary because the function returns an array of values
and you just want the data from the first row and column.
On Mon, Dec 4, 2017 at 1:26 PM, myriad58@
...
wrote:
>
> I have switched over to the smfGetYahooPortfoli
> having trouble with currency exchange. I have this function which writes
> the current USD/CAN exchange rate to be used to re-calculate my USD stocks
> into CDN $ values:
>
> dRate = smfGetYahooPortfoli
> "=X"
> would ultimately like the variable dRate to hold the exchange value like it
> used to do with the now deprecated =RCHGetYahooQuotes add-in.
>
Mon Dec 4, 2017 2:34 pm (PST) . Posted by:
myriad58
That was it! I had tried that "dRate = RCHGetYahooQuotes(Range("h5").Value & Range("h6").Value & "=X", "l1")(1, 1)" and it didn't work - probably because I had put 2 arguments in for the second value rather than '15'. Thanks again!
Mon Dec 4, 2017 12:39 pm (PST) . Posted by:
boothman11
I used the GetYahooQuotes function for the last 6 years or so. Like everyone else, it stopped working for me last month. I installed the new file and confirmed it was working with the RCHGetElementNumber formula.
However, no matter what I try, this GetYahooPortfolioView function will not work at all. No matter what I try, it just returns "#NAME?". Is anyone else having this problem? Is there a fix coming or is it me?
However, no matter what I try, this GetYahooPortfolioVi
Mon Dec 4, 2017 12:42 pm (PST) . Posted by:
boothman11
I should note that I cannot get the Array function to work. I keep pressing "ctrl+shift+enter" after highlighting the cells I wants to turn into an array and nothing happens. No brackets get added to the formula.
Mon Dec 4, 2017 12:59 pm (PST) . Posted by:
boothman11
I uninstalled and resinstalled it and it worked. I probably was doing something wrong the first time. Anyway, so thankful for the person who makes this Add-In possible. It's a lifesaver.
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar