New web query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using the 'new web query' function, e.g. a share price from Bloomberg USD100, how can I get rid of the USD part to be able to use the value only. At the moment if I have 20 shares I have to type in the value for the calculation. USD100x20 doesn't work
 
Dear Arturus
Add a new column to your sheet, type in =LEFT(A1,3), then
copy the formula down the range containing the rates -
please remember to change A! to the address of the cell
containing your rate.

HTH

Paul
-----Original Message-----
Using the 'new web query' function, e.g. a share price
Click to expand...
from Bloomberg USD100, how can I get rid of the USD part
to be able to use the value only. At the moment if I have
20 shares I have to type in the value for the calculation.
USD100x20 doesn't work.
 
If the share price is in cell B2, and share quantity is in cell C2:

=RIGHT(B2,LEN(B2)-3)*C2
 
Back
Top