VBA Excel Enhanced Lookup user defined function
€30-250 EUR
Pagado a la entrega
ENHANCED LOOKUP EXCEL VBA USER DEFINED FUNCTION
- In a "source" sheet are downloaded financial data for multiple securtities. Example: date, volume, close, high, low
- For each security, the subset of data may be different:
Example:
security 1 has a set of monthly close price only (Column A: Date, Column B: Price)
security 2 has daily prices with high, low, volume, close (Column D: Date, Column E: High, Column F: Low etc.)
- We want to develop a VBA excel user defined function as follows:
Value = DataPoint(Sheetname of Database; Ticker; Field; Date)
- Clean example of the data source and it's format is provided, as well as how we want the function to work in the attached spreadsheet
- We want the code to be visible in the vb editor
- BEWARE:
(i) this is not a plain "indexmatch" type of function as the funtion will need to identify a correct subset of data within a data source sheet first
(ii) however this is a reasonably easy job for the right VBA experienced freelancer
(iii) we are open to have REASONABLE format constraint on the source of data
Nº del proyecto: #8868385
Sobre el proyecto
Adjudicado a:
Hello Manal, Its a privilege to get opportunity to work with you again. I have duly understood the concept and the requirements of the advanced search "Function" that you need here. It can be done and considering th Más
25 freelancers están ofertando un promedio de €108 por este trabajo
Hi, my name is Sevinc. I read your excel VBA pfunction roject descriptions carefully before bidding. I got what you need and ready to go ahead as soon as we can clarify further project details. I am 5-star excel an Más
Dear, I m studying the description you provided here and in the Excel file. I need few minutes to understand the logic and provide a clear answer. Also please feel free to speak French if you like. Can you open a discu Más
Lets start. Having a team of Professionals. We provide high quality work with accuracy. Would you like to discuss more about your current requirements?
Hello I went through your description provided and it looks like very much doable for me. I can get you this function( datapoint) written using VBA Programming. However, you can use this as a simple formula from Más
I can do it | I can do it | I can do it | I can do it | I can do it | I can do it | I can do it | I can do it | I can do it | I can do it | I can do it | I can do it |
Hi there, I’d like to be considered for your bid. I am a software developer with a strong background developing excel, access related applications, including excel functions,active x objects, sql server as backend, dat Más
Hi, I already have the file ready. I was able to create the formula that you need. Please send a message so that we can discuss and I can send my initial draft to you. Thanks.
I have read and fully understood your requirements.. Please open chat to discuss further.. ========================================================================
with over 18 years of experience in Excel and advanced Visual Basic/VBA skills, immediate availability and understanding of need for accuracy and reliability, I feel I am the best candidate for this project