I want to get an accurate model of a real inductor in LTSpice. Therefor I used an Bode 100 Network Analyzer und measured its impedance in a range of 100 Hz to 20 MHz. My idea was to calculate the capacitance of the inductor from the resonant frequency of the inductor like this (rearranged formula from wikipedia for a real parallel resonant circuit):
$$ C=\dfrac{1}{L\omega_r^2+\dfrac{R_L^2}{L}}$$
However, I have not been that satisfied with the results, when using this model in LTSpice. The inductor will be used in a resonant circuit, whose resonant frequency is approximately at 7 MHz. Can this inductor be modelled more accurately?
Impedance of the inductor (measured in inductance and serial resistance, the narrow one is the serial resistance):
Comparison of the impedances in LTSpice and the Bode 100: