VBA Excel Enhanced Lookup user defined function
€30-250 EUR
ชำระเงินเมื่อจัดส่ง
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
หมายเลขโปรเจค: #8868385
เกี่ยวกับโปรเจกต์
มอบให้กับ:
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 เพิ่มเติม
freelancer 25 คน กำลังเสนอราคาในงานนี้ โดยมีราคาเฉลี่ยอยู่ที่ €108
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 เพิ่มเติม
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 เพิ่มเติม
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 เพิ่มเติม
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 เพิ่มเติม
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