=WEBSERVICE formula help

[redspanna]

Hi all

I'm simply try to get current portfolio value of a certain Crypto in Cell range D4:D9
By this I mean multiply QTY (column B) of the stock by current value (column C)
However if I enter into column D the simple formula =C4*B4 then I get a #VALUE! error
The formula in Column C is using a =WEBSERVICE formula

Book1
	A	B	C	D
1	https://cryptoprices.cc/
2
3	COIN	QTY	CURRENT PRICE	EST.VALUE
4	RNDR	54642	1.75	#VALUE!
5	KAS	233	0.04887369
6	RFOX	145	0.01087123
7	AZERO	200	0.808871
8	BBANK	565663	0.01978743
9	KUJI	221	0.688078
Spots

Cell Formulas
Range	Formula
D4	D4	=C4*B4
C4:C9	C4	=WEBSERVICE(endpoint&"/"&A4)

Named Ranges
Name	Refers To	Cells
endpoint	=Spots!$A$1	C4:C9

so in above example column D should result in following
D4 = 95,623
D5 = 11.37

etc

Appreciate any help

 

[Fluff]

No idea why it doesn't work for you, but webservice works for me

Fluff.xlsm
	A	B	C	D	E	F	G
1		https://cryptoprices.cc/
2
3	BOUGHT	COIN	QTY	AVG BUY PRICE	COST (USDT)		CURRENT PRICE
4	45193	RNDR	510.85	1.566	799.9911	https://cryptoprices.cc/RNDR	934.8555
5	45193	KAS	14324.68	0.047464	679.906612	https://cryptoprices.cc/KAS	699.046533
6	45193	RFOX	55381.42	0.009028	499.994536	https://cryptoprices.cc/RFOX	539.119294
7	45193	AZERO	473.1	0.84548	399.996588	https://cryptoprices.cc/AZERO	377.45905
8	45204	BBANK	13570.3202	0.017649	239.502581	https://cryptoprices.cc/BBANK	277.46528
9	45204	KUJI	491.07	0.69	338.8383	https://cryptoprices.cc/KUJI	372.995656
Sheet6

Cell Formulas
Range	Formula
E4:E9	E4	=C4*D4
F4:F9	F4	=$B$1&B4
G4:G9	G4	=NUMBERVALUE(WEBSERVICE(F4))*C4

 

[redspanna]

No idea why it doesn't work for you, but webservice works for me

Fluff.xlsm
	A	B	C	D	E	F	G
1		https://cryptoprices.cc/
2
3	BOUGHT	COIN	QTY	AVG BUY PRICE	COST (USDT)		CURRENT PRICE
4	45193	RNDR	510.85	1.566	799.9911	https://cryptoprices.cc/RNDR	934.8555
5	45193	KAS	14324.68	0.047464	679.906612	https://cryptoprices.cc/KAS	699.046533
6	45193	RFOX	55381.42	0.009028	499.994536	https://cryptoprices.cc/RFOX	539.119294
7	45193	AZERO	473.1	0.84548	399.996588	https://cryptoprices.cc/AZERO	377.45905
8	45204	BBANK	13570.3202	0.017649	239.502581	https://cryptoprices.cc/BBANK	277.46528
9	45204	KUJI	491.07	0.69	338.8383	https://cryptoprices.cc/KUJI	372.995656
Sheet6

Cell Formulas
Range	Formula
E4:E9	E4	=C4*D4
F4:F9	F4	=$B$1&B4
G4:G9	G4	=NUMBERVALUE(WEBSERVICE(F4))*C4

me neither - but appreciate your reply

 

[jdellasala]

No idea why it doesn't work for you, but webservice works for me

Fluff.xlsm
	A	B	C	D	E	F	G
1		https://cryptoprices.cc/
2
3	BOUGHT	COIN	QTY	AVG BUY PRICE	COST (USDT)		CURRENT PRICE
4	45193	RNDR	510.85	1.566	799.9911	https://cryptoprices.cc/RNDR	934.8555
5	45193	KAS	14324.68	0.047464	679.906612	https://cryptoprices.cc/KAS	699.046533
6	45193	RFOX	55381.42	0.009028	499.994536	https://cryptoprices.cc/RFOX	539.119294
7	45193	AZERO	473.1	0.84548	399.996588	https://cryptoprices.cc/AZERO	377.45905
8	45204	BBANK	13570.3202	0.017649	239.502581	https://cryptoprices.cc/BBANK	277.46528
9	45204	KUJI	491.07	0.69	338.8383	https://cryptoprices.cc/KUJI	372.995656
Sheet6

Cell Formulas
Range	Formula
E4:E9	E4	=C4*D4
F4:F9	F4	=$B$1&B4
G4:G9	G4	=NUMBERVALUE(WEBSERVICE(F4))*C4

I'm on the Insider Beta edition. It also doesn't work on Excel Web.