6 Messages
Digest #4264
Messages
Wed Dec 13, 2017 12:14 pm (PST) . Posted by:
a.bereziuk
Does processing of multiple tickers over a range with
=smfGetTagContent("https://finviz.com/quote.ashx?ta=1&p=d&t= https://finviz.com/quote.ashx?ta=1&p=d&t="&smfJoin($B$3:$B$102,","),"td",1,"?t="&$B3&"&",">"&K$2,,,1)
work only with FinViz?
=smfGetTagContent("https://finviz.com/quote.ashx?ta=1&p=d&t= https://finviz.com/quote.ashx?ta=1&p=d&t="&smfJoin(
work only with FinViz?
Wed Dec 13, 2017 12:21 pm (PST) . Posted by:
a.bereziuk
What would this return:
=smfGetYahooPortfolioView(B6:B8,"15")
B6:B8 - range of tickers
=smfGetYahooPortfol
B6:B8 - range of tickers
Wed Dec 13, 2017 12:32 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
That technique should work for any web page that provides data for multiple
tickers. The smfGetYahooPortfolioView() and smfGetBarchartPortfolioView()
functions are examples of other web pages (actually JSON files) that
provide a similar capability. It's just that I wrote a specific function
for their data.
I did start work on an smfGetFinVizPortffolioView() doing the same thing,
but it was so slow I abandoned it (for now).
On Wed, Dec 13, 2017 at 1:14 PM, a.bereziuk@yahoo.de [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Does processing of multiple tickers over a range with
>
> =smfGetTagContent("https://finviz.com/quote.ashx?ta=1&p=d&t=
> "&smfJoin($B$3:$B$102,","),"td",1,"?t="&$B3&"&",">"&K$2,,,1)
>
> work only with FinViz?
>
tickers. The smfGetYahooPortfolioView() and smfGetBarchartPortfolioView()
functions are examples of other web pages (actually JSON files) that
provide a similar capability. It's just that I wrote a specific function
for their data.
I did start work on an smfGetFinVizPortffolioView() doing the same thing,
but it was so slow I abandoned it (for now).
On Wed, Dec 13, 2017 at 1:14 PM, a.bereziuk@yahoo.de [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Does processing of multiple tickers over a range with
>
> =smfGetTagContent("https://finviz.com/quote.ashx?ta=1&p=d&t=
> "&smfJoin(
>
> work only with FinViz?
>
Wed Dec 13, 2017 12:36 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
The B6:C8 range looks like this for me:
MMM 238.98
IBM 154.4249
SPY 267.12
On Wed, Dec 13, 2017 at 1:21 PM, a.bereziuk@
...
wrote:
>
> What would this return:
>
> =smfGetYahooPortfolioView(B6:B8,"15")
>
>
> B6:B8 - range of tickers
>
>
MMM 238.98
IBM 154.4249
SPY 267.12
On Wed, Dec 13, 2017 at 1:21 PM, a.bereziuk@
...
wrote:
>
> What would this return:
>
> =smfGetYahooPortfol
>
>
> B6:B8 - range of tickers
>
>
Wed Dec 13, 2017 4:39 pm (PST) . Posted by:
v4pnaah6cygf2nzx2356pl2ugoa3ti5fowi4gdzj
I'm confused about the status of the function.
Recently installed http://ogres-crypt.com/SMF/RCH_Stock_Market_Functions-2.1.2017.11.30.zip http://ogres-crypt.com/SMF/RCH_Stock_Market_Functions-2.1.2017.11.30.zip
Using array entered
=RCHGetYahooHistory(B$3,2017,1,1,2017,12,31,"d","DO",0,,1)
I get historical data, but it is all adjusted. I want the "raw" price data.
If I change the 0,,1 to 0,0,1, I get an error "all data is adjusted".
If I go to the finance.yahoo.com web site and download a csv file, I see the raw data for open, high, low, close.
Is it not possible to somehow get the raw historical data with RCHGetYahooHistory( ) ?
(or some other function?)
Thanks.
Ron Johnson
Recently installed http://ogres-crypt.com/SMF/RCH_Stock_Market_Functions-2.1.2017.11.30.zip http://ogres-crypt.com/SMF/RCH_Stock_Market_Functions-2.1.2017.11.30.zip
Using array entered
=RCHGetYahooHistory
I get historical data, but it is all adjusted. I want the "raw" price data.
If I change the 0,,1 to 0,0,1, I get an error "all data is adjusted"
If I go to the finance.yahoo.
Is it not possible to somehow get the raw historical data with RCHGetYahooHistory( ) ?
(or some other function?)
Thanks.
Ron Johnson
Wed Dec 13, 2017 4:50 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
You can get closing price adjusted or unadusted, as stated by Yahoo.
However, the RCHGetYahooHistory() function now adjusts open/high/low
prices. If you need those unadjusted, you'd have to compute them yourself
using the adjusted and unadusted prices.
Sorry, but there were just too many changes being made by Yahoo, and that's
how things panned out, especially since using unadjusted prices makes no
sense to me.
Why would it matter what the price was 5 years ago, unadjusted for splits,
dividends, spinoffs, and mergers?
On Wed, Dec 13, 2017 at 3:35 PM, v4pnaah6cygf2nzx2356pl2ugoa3ti5fowi4gdzj@
...
wrote:
> I'm confused about the status of the function.
>
> Recently installed http://ogres-crypt.com/SMF/RCH_Stock_Market_
> Functions-2.1.2017.11.30.zip
>
> Using array entered
>
> =RCHGetYahooHistory(B$3,2017,1,1,2017,12,31,"d","DO",0,,1)
>
> I get historical data, but it is all adjusted. I want the "raw" price
> data.
>
> If I change the 0,,1 to 0,0,1, I get an error "all data is adjusted".
>
> If I go to the finance.yahoo.com web site and download a csv file, I see
> the raw data for open, high, low, close.
>
> Is it not possible to somehow get the raw historical data with RCHGetYahooHistory(
> ) ?
>
> (or some other function?)
>
>
>
However, the RCHGetYahooHistory() function now adjusts open/high/low
prices. If you need those unadjusted, you'd have to compute them yourself
using the adjusted and unadusted prices.
Sorry, but there were just too many changes being made by Yahoo, and that's
how things panned out, especially since using unadjusted prices makes no
sense to me.
Why would it matter what the price was 5 years ago, unadjusted for splits,
dividends, spinoffs, and mergers?
On Wed, Dec 13, 2017 at 3:35 PM, v4pnaah6cygf2nzx2356pl2ugoa3ti5fowi4gdzj@
...
wrote:
> I'm confused about the status of the function.
>
> Recently installed http://ogres-crypt.com/SMF/RCH_Stock_Market_
> Functions-2.
>
> Using array entered
>
> =RCHGetYahooHistory
>
> I get historical data, but it is all adjusted. I want the "raw" price
> data.
>
> If I change the 0,,1 to 0,0,1, I get an error "all data is adjusted"
>
> If I go to the finance.yahoo.
> the raw data for open, high, low, close.
>
> Is it not possible to somehow get the raw historical data with RCHGetYahooHistory(
> ) ?
>
> (or some other function?)
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar