I gang

Add functions to the last project

Ok Andrew,

So that's what I'd like to add..

I know that generally, adding a cell between B and C may completely have an impact on the code,

I'd like to add a column between B and C in order to add the beginning date of the stocks (referent stocks EXCLUDED)

Moreover, can you take a small look at my first macro getquotes()

(the one that gets the data from bloomberg..) in order to not having to put the referent stock under the "stocks" column A but just under "referent"

Finally you'll see a new worksheet called sheet2 which is a database of stocks that can grow (adding new lines each time I have new data)

Is it possible just to generate on a new worksheet a chart with the names of the stocks that are under the stocks "column" (referent stocks EXCLUDED AGAIN) with the data (sort of VLOOKUP or HLOOKUP)?

Best regards

Walid

Færdigheder: Excel, Visual Basic for Apps

Se mere: walid , c bloomberg, sort macro, bloomberg database, cell names, add stock, project macro, last names, bloomberg data, data bloomberg, vlookup project, stock macro, macro add, last project, project vlookup, small project macro, macro bloomberg, add chart database, hlookup, vlookup add, macro project, vlookup adding, add last, vlookup macro, stocks chart

Om arbejdsgiveren:
( 2 bedømmelser ) Paris, France

Projekt-ID: #4038654

Tildelt til:

buyaspreadsheet

Hired by the Employer

$40 USD på 1 dag
(15 bedømmelser)
4.6